Forecasting BUBBLE CASE.xls - INPUTS OUTPUTS Number of Periods in Moving Average = Number of Periods of Data Collected = MSE = MAD = OUTPUTS Forecast =

Forecasting BUBBLE CASE.xls - INPUTS OUTPUTS Number of...

This preview shows page 1 - 18 out of 29 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 in Moving Average = Number of Periods of Data Collected = MSE = MAPE = MAD = LAD = OUTPUTS Forecast = for periods or more Past Period 1 2 3 4 5 6 7 8 Weighting Absolute Error Absolute Period Value Forecast Error Error Squared % Error
Image of page 5
Image of page 6
9 10 11 12 13 14 15
Image of page 7
Image of page 8
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 9
Image of page 10
Image of page 11
Image of page 12
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 13
Image of page 14
Image of page 15
Image of page 16
INPUTS OUTPUTS Number of Periods of Data Collected = Period Forecast = Smoothing Constant (alpha) ===
Image of page 17
Image of page 18

You've reached the end of your free preview.

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