Question: Please answer the following problem woth excel. Thank you! A and C only! 13. Use Holt's method to create a model that minimizes the MSE

13. Use Holt's method to create a 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 Holt's method versus the original data. c. What are the forecasts for the next 2 years using this technique? \begin{tabular}{cc} Year & Avg Price \\ \hline 1 & $114,400 \\ 2 & $115,300 \\ 3 & $124,700 \\ 4 & $126,600 \\ 5 & $129,300 \\ 6 & $133,500 \\ 7 & $135,800 \\ 8 & $141,800 \\ 9 & $150,500 \\ 10 & $159,100 \\ 11 & $168,300 \\ 12 & $176,200 \\ 13 & $185,300 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
