Use Holts method to create a model that minimizes the MSE for the data set. Use Solver

Question:

Use Holt’s method to create a model that minimizes the MSE for the data set. Use Solver to estimate the optimal values of a and b.

a. What are the optimal values of a and b?
b. Prepare a line graph comparing the predictions from Holt’s method against the original data.
c. What are the forecasts for the next 4 months using this technique?

Step by Step Answer:

Question Posted: