Copy of Forecast Seasonal Model.xlsx - INPUTS OUTPUTS Number of Periods in Moving Average = Number of Periods of Data Collected = MSE = MAD = OUTPUTS

Copy of Forecast Seasonal Model.xlsx - INPUTS OUTPUTS...

This preview shows page 1 - 14 out of 23 pages.

INPUTS OUTPUTS Number of Periods in Moving Average = Number of Periods of Data Collected = MSE = MAPE = MAD = LAD = OUTPUTS Forecast = for periods or more Absolute Error Absolute Period Value Forecast Error Error Squared % Error
Image of page 1
Image of page 2
Image of page 3
Image of page 4
INPUTS OUTPUTS Number of Periods of Data Collected = Smoothing Constant (alpha) ======= MSE = MAPE = Initial Forecast Value (do not enter) MAD = LAD = OUTPUTS Forecast = for periods or more Absolute Error Absolute Period Value Forecast Error Error Squared % Error
Image of page 5
Image of page 6
Image of page 7
Image of page 8
INPUTS OUTPUTS Number of Periods of Data Collected = Period Forecast = MSE = MAPE = MAD = LAD = OUTPUTS Period Forecast Absolute Error Absolute Period Value Forecast Error Error Squared % Error
Image of page 9
Image of page 10
Image of page 11
Image of page 12
SUMMARY OUTPUT Regression Statistics Multiple R 0.898713 R Square 0.807685 Adjusted R 0.756401 Standard E 11.43678 Observatio 20 ANOVA df SS MS F ignificance F Regression 4 8240 2060 15.74924 3.01E-005 Residual 15 1962 130.8 Total 19 10202 Coefficients tandard Erro t Stat P-value Lower 95%Upper 95% Lower 95.0% Upper 95.0% Intercept 90.5 7.45587 12.13809 3.70E-009 74.60819 106.3918 74.60819 106.3918 Period 0.375 0.452079 0.829502 0.419826 -0.588583 1.338583 -0.588583 1.338583 1 30.125 7.359305 4.093457 0.000959 14.43901 45.81099 14.43901 45.81099 2 57.75 7.289547 7.922303 9.71E-007 42.2127 73.2873 42.2127 73.2873 3 26.375 7.24737 3.639251 0.002423 10.9276 41.8224 10.9276 41.8224
Image of page 13
Image of page 14

You've reached the end of your free preview.

Want to read all 23 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