Share
Explore BrainMass

Problem analysis--time series

1. Corporate triple A bond interest rates for 12 consecutive months are given below.

Month Interest rate
1 9.5
2 9.3
3 9.4
4 9.6
5 9.8
6 9.7
7 9.8
8 10.5.
9 9.9
10 9.7
11 9.6
12 9.6

A) Develop 3-month moving average for this time series. [Make sure that there is only one value lost at the start and one at the end.].

B) Plot the series in line chart using MS Excel. Show the trend line

2. SPC of Package Delivery Service
A private mail delivery service has a policy of guaranteeing delivery by 11:00 A.M. on the morning after a package is picked up. Suppose that the management of the service wishes to check the delivery performance in a particular area over a 2-week time period based on a five-day workweek. The total number of packages delivered daily and the number of packages that were not delivered by 11:00 A.M are shown below:

Day Packages Delivered Packages not Arriving before 11:00 A.M.
1 136 4
2 153 6
3 127 2
4 157 7
5 144 5
6 122 5
7 154 6
8 132 3
9 160 8
10 142 7

A) Develop mean chart and range chart for the above data. [use Megastat, p-chart function].

B) Based on the above data, we can conclude that the postal delivery process is out of control?

Attachments

Solution Summary

Problem analysis for time-series is given.

$2.19