Refer to the data in the file that accompanies this book named MortgageRates.xlsx containing average monthly 30-year mortgage rates over 82 consecutive months.

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 2 months using this technique?