1 / 13

Forecasting

Forecasting. Time Series Analysis - Projecting future values from historical trends. Approaches. Moving Average Weighted Moving Average Exponential Smoothing. Data Collection. More Data is Better GIGO (garbage in garbage out) Timely Relevant. Three Year Moving Average.

derica
Download Presentation

Forecasting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Forecasting Time Series Analysis - Projecting future values from historical trends.

  2. Approaches • Moving Average • Weighted Moving Average • Exponential Smoothing

  3. Data Collection • More Data is Better • GIGO (garbage in garbage out) • Timely • Relevant

  4. Three Year Moving Average • Forecastt = (Salest-1 +Salest-2 + Salest-3)/3

  5. Three Year Weighted Moving Average • Forecast = W1 Salest-1 + W2 Salest-2 + W3 Salest-3 • W1+W2+W3 = 1 • The most recent period is generally the best indicator and therefore gets the greatest weight.

  6. Number of Periods and Weighting • A shorter time period reacts more quickly and is more appropriate when the series is less stable. • Greater weights should be applied to more recent periods when the series is less stable.

  7. Exponential Smoothing • Forecastt = Forecastt-1 +  (Salest-1-Forecastt-1) • A large Alpha () emphasizes recent demand therefore it is more responsive to changes in the underlying average. • The starting Forecast is generally the Actual for that period.

  8. Evaluating Forecast Models • Cumulative Forecast Error - CFE • Mean Absolute Deviation - MAD • Root Mean Square Error -RMSE

  9. Cumulative Forecast Error(CFE) • Errort = Actualt - Forecastt • CFE =  Errors • This measures bias, or whether the forecast is consistently above or below the actual. The smaller the CFE the less bias.

  10. Mean Absolute Deviation (MAD) MAD =  Absolute Value(Errors) n This is the average absolute error. The lower the MAD, the better the model.

  11. Root Mean Square Error (RMSE) RMSE =  Errors2 n This is the standard deviation of the errors around the actual values. The lower the RMSE the better the model.

  12. Numeric Example

  13. Excel Example • Develop a forecast for 1998 using: • 3 year moving average • 3 year weighted moving average (.7, .2, .1) • Exponential Smoothing ( = .15)

More Related