Explore BrainMass

Explore BrainMass

    Problem analysis--time series

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com June 3, 2020, 7:54 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/problem-analysis-time-series-116438

    Attachments

    Solution Summary

    Problem analysis for time-series is given.

    $2.19

    ADVERTISEMENT