Purchase Solution

Problem analysis--time series

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution
Solution Summary

Problem analysis for time-series is given.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Multiple Regression & Time Series Forecasting

    446898 Multiple Regression & Time Series Forecasting The CEO noticed that he has five years of quarterly sales data in hand, and they form a time series.

  • Time Series Forecast

    This solution is comprised of a detailed analysis of the given problem and step-by-step calculations in EXCEL and provides students with a clear perspective of the underlying concepts of Time Series Forecast Analysis.

  • Time Series Data: Forecast Yearly Advertising Costs

    148870 Time Series Data: Forecast Yearly Advertising Costs Please see attached file for full problem description.

  • Time Series and Forecasting

    42052 Time Series and Forecasting: Example Problem Do time series models rely heavily on cause and effect relationships between variables in order to ensure accurate predictions?

  • Time series forecasting problem

    122259 Time series forecasting problem Problem (see attached file) we are going time series techniques to predict non-retail sales for the next three months. Use the data in the file non retail time series for these exercises. 1.

  • Predicting forecast based on given trend line equation

    of the given problem related to a time series analysis in EXCEL and provides students with a clear perspective of the underlying concept.

  • Economic polls and forecasting

    Quantitative methods are grouped into one of two categories: time-series (or historical data) analysis and causal methods.

  • A problem on Regression analysis

    Regards This posting contains solution to following problem on Regression analysis.

  • Time Series Analysis

    step-by-step calculations and analysis of the given problem and provides students with a clear perspective of the underlying concept.

View More Related Solutions