Question: ( b ) Develop a three - week moving average for this time series. Compute MSE and a forecast for week 7 . Do not

(b) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7.
Do not round intermediate calculations. If required, round your answers to two decimal places.
\table[[Week Value,Forecast,],[1,16,],[2,14,],[3,15,],[4,12,],[5,16,],[6,13,]]
MSE
The forecast for week 7 :
(c) Use a=0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7.
Do not round intermediate calculations. If required, round your answers to two decimal places.
\table[[Week,Value,Forecast],[1,16,],[2,14,],[3,15,],[4,12,],[5,16,],[6,13,]]
MSE:
The forecast for week 7 :
(d) Compare the three-week moving average forecast with the exponential smoothing forecast using =0.2. Which appears to provide the better forecast based on MSE?
Select your answer -
Explain.
Using this approach results in a
ASE. alpha:
 (b) Develop a three-week moving average for this time series. Compute

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!