Forecast 022619.xlsx - INPUTS OUTPUTS Number of Periods in Moving Average = Number of Periods of Data Collected = 3 12 MSE = MAD = OUTPUTS Forecast =

Forecast 022619.xlsx - INPUTS OUTPUTS Number of Periods in...

This preview shows page 1 - 16 out of 16 pages.

INPUTS OUTPUTS Number of Periods in Moving Average = 3 Number of Periods of Data Collected = 12 MSE = 10.2222 MAPE = MAD = 2.66667 LAD = OUTPUTS Forecast = 19 for periods 13 or more Absolute Error Absolute Period Value Forecast Error Error Squared % Error 1 17 2 21 3 19 4 23 19 4 4 16 0.173913 5 18 21 -3 3 9 0.166667 6 16 20 -4 4 16 0.25 7 20 19 1 1 1 0.05 8 18 18 0 0 0 0 9 22 18 4 4 16 0.181818 10 20 20 0 0 0 0 11 15 20 -5 5 25 0.333333 12 22 19 3 3 9 0.136364 13 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19
Image of page 1
19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19 19
Image of page 2
14.35661 5
Image of page 3
Image of page 4
INPUTS OUTPUTS Number of Periods of Data Collected = 12 Smoothing Constant (alpha) ======= 0.2 MSE = 8.982231 MAPE = Initial Forecast Value (do not enter) 17 MAD = 2.596339 LAD = OUTPUTS Forecast = 19.18496 for periods 13 or more Absolute Error Absolute Period Value Forecast Error Error Squared % Error 1 17 17 0 0 0 0 2 21 17 4 4 16 0.190476 3 19 17.8 1.2 1.2 1.44 0.063158 4 23 18.04 4.96 4.96 24.6016 0.215652 5 18 19.032 -1.032 1.032 1.065024 0.057333 6 16 18.8256 -2.8256 2.8256 7.984015 0.1766 7 20 18.26048 1.73952 1.73952 3.02593 0.086976 8 18 18.60838 -0.608384 0.608384 0.370131 0.033799 9 22 18.48671 3.513293 3.513293 12.34323 0.159695 10 20 19.18937 0.810634 0.810634 0.657128 0.040532 11 15 19.35149 -4.351493 4.351493 18.93549 0.2901 12 22 18.48119 3.518806 3.518806 12.382 0.159946 13 19.18496 19.18496 19.18496 19.18496 19.18496 19.18496 19.18496 19.18496 19.18496 19.18496 19.18496
Image of page 5
Image of page 6
Image of page 7
Image of page 8
Image of page 9
Image of page 10
Image of page 11
Image of page 12
Image of page 13
Image of page 14
Image of page 15
Image of page 16

You've reached the end of your free preview.

Want to read all 16 pages?

  • Winter '10
  • goldstein
  • Prime number, lad, Number of Periods of Data Collected

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture