Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the...

Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes

the MSE for the data set. Use Solver to determine the optimal values of , , and .

a. What are the optimal values of , , and ?

b. Prepare a line graph comparing the predictions from this method against the original data. c. What are the forecasts for the next four months using this technique?

54. Prepare a line graph of these data. Do the data appear to be stationary or nonstationary?