Question: Create an exponential smoothing model that minimizes the MSE for the

Create an exponential smoothing model that minimizes the MSE for the data set. Use Solver to estimate the optimal value of α.
a. What is the optimal value of α?
b. Prepare a line graph comparing the exponential smoothing predictions against the original data.
c. What are the forecasts for weeks 23 and 24 using this technique?


View Solution:


Sale on SolutionInn
Sales1
Views144
Comments
  • CreatedNovember 03, 2012
  • Files Included
Post your question
5000