Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Compute MSE. (Ro

[answerhappygod]

Develop the three-week moving average for this time series.(Round your answers to two decimal places.)
Compute MSE. (Round your answer to two decimal places.)
MSE =
What is the forecast for week 7?
(c)
Use 𝛼 = 0.2 to compute the exponential smoothingvalues for the time series.
Compute MSE. (Round your answer to two decimal places.)
MSE =
What is the forecast for week 7? (Round your answer to twodecimal places.)
(d)
Compare the three-week moving average forecast with theexponential smoothing forecast using
𝛼 = 0.2.
Which appears to provide the better forecast based on MSE?Explain.
The exponential smoothing using 𝛼 = 0.2 provides abetter forecast since it has a smaller MSE than the three-weekmoving average approach.The three-week moving average provides abetter forecast since it has a larger MSE than the smoothingapproach. The exponential smoothingusing 𝛼 = 0.2 provides a better forecast since it has alarger MSE than the three-week moving average approach.Thethree-week moving average provides a better forecast since it has asmaller MSE than the smoothing approach.
(e)
Use 𝛼 = 0.4 to compute the exponential smoothingvalues for the time series.
Does a smoothing constant of 0.2 or 0.4 appear to provide moreaccurate forecasts based on MSE? Explain.
The exponential smoothing using 𝛼 = 0.2 provides abetter forecast since it has a larger MSE than the exponentialsmoothing using 𝛼 = 0.4.The exponential smoothingusing 𝛼 = 0.4 provides a better forecast since it has alarger MSE than the exponential smoothing using 𝛼 =0.2. The exponential smoothingusing 𝛼 = 0.4 provides a better forecast since it has asmaller MSE than the exponential smoothing using 𝛼 =0.2.The exponential smoothing using 𝛼 = 0.2 provides abetter forecast since it has a smaller MSE than the exponentialsmoothing using 𝛼 = 0.4.