Consider the quarterly sales data for Worthington Health Club shown below: Quarter Total Year 1 2...

  

Transcribed Image Text:

Consider the quarterly sales data for Worthington Health Club shown below: Quarter Total Year 1 2 3 4 Sales 1 5 4 2 6 3 11 4 5 11 19 1 262 2 +31 9 5 15 17 28 19 37 10 20 51 12 33 72 8 a. Develop a four-period moving average model and compute MSE for your forecasts. Do not round intermediate calculations. Round your answers to two decimal places. MSE (4-period): Time Period Observation Forecast 1 5 2 4 3 1 4 5 5 6 6 3 7 2 8 17 9 11 10 1 11 6 12 19 13 11 14 10 15 10 16 20 17 19 18 8 19 12 20 33 b. Find the best single exponential smoothing model by evaluating the MSE from 0.1 to 0.9, in increments of 0.1. Do not round intermediate calculations. Round your answers to two decimal places. The model based on a smoothing constant of -Select- is the best. How does this model compare with the moving average model? model has the lowest MSE. The -Select- Alpha MSE 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 Consider the quarterly sales data for Worthington Health Club shown below: Quarter Total Year 1 2 3 4 Sales 1 5 4 2 6 3 11 4 5 11 19 1 262 2 +31 9 5 15 17 28 19 37 10 20 51 12 33 72 8 a. Develop a four-period moving average model and compute MSE for your forecasts. Do not round intermediate calculations. Round your answers to two decimal places. MSE (4-period): Time Period Observation Forecast 1 5 2 4 3 1 4 5 5 6 6 3 7 2 8 17 9 11 10 1 11 6 12 19 13 11 14 10 15 10 16 20 17 19 18 8 19 12 20 33 b. Find the best single exponential smoothing model by evaluating the MSE from 0.1 to 0.9, in increments of 0.1. Do not round intermediate calculations. Round your answers to two decimal places. The model based on a smoothing constant of -Select- is the best. How does this model compare with the moving average model? model has the lowest MSE. The -Select- Alpha MSE 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9

Answer rating: 100% (QA)

Part a FourPeriod Moving Average Model To develop a fourperiod moving average model well take the av... View the full answer