Smoothing Constant gamma MSE MAPE Initial Forecast Value Level do not enter MAD

Smoothing constant gamma mse mape initial forecast

This preview shows page 17 - 26 out of 32 pages.

Smoothing Constant (gamma) === MSE = MAPE = Initial Forecast Value (Level) (do not enter) MAD = LAD = Initial Forecast Value (Trend) (do not enter) OUTPUTS Period Forecast Forecast Forecast Absolute Error Absolute Period Value Level Trend Forecast Error Error Squared % Error
Image of page 17
Image of page 18
Image of page 19
Image of page 20
INPUTS OUTPUTS Number of Periods of Data Collected = Period Forecast = Number of Seasons =========> MSE = MAPE = MAD = LAD = OUTPUTS Period Forecast Centered Seasonal/ Desesonalized Absolute Error Absolute Period Value Moving Av. Random Values Forecast Error Error Squared
Image of page 21
Image of page 22
% Error Season Index #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Image of page 23
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Image of page 24
INPUTS Number of Periods of Data Collected = 16 Number of Seasons =========> 4 Forecast up to period = 30 Coefficients from regression output intercept slope SI1 SI2 SI3 SI4 SI5 SI6 SI7 6.06875 0.145625 -1.363125 -2.03375 -0.304375 Seasonal Factors Value Period 1 2 3 4 5 6 7 4.8 1 1 0 0 4.1 2 0 1 0 6.0
Image of page 25
Image of page 26

You've reached the end of your free preview.

Want to read all 32 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes