Question: please use excel and show formulas! thank you! 5. ( 2 points) Using Holt's method with a smoothing constant a=0.3 and a trend constant =0.6,

please use excel and show formulas! thank you!
please use excel and show formulas! thank you! 5.
please use excel and show formulas! thank you! 5.
5. ( 2 points) Using Holt's method with a smoothing constant a=0.3 and a trend constant =0.6, what is the forecast for 1/2/2016 ? It's okay if your forecast goes negative at some points (although it shouldn't be negative for 1/2/2016 ). 6. ( 2 points) What is the RMSE if we use a smoothing constant a=0.3 and a trend constant =0.6 ? 7. (6 points) What are the optimal constants a and (use increments of .05 for each)? What is the RMSE when these optimal constants are used

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!