I need the answer for (e) : Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.20. Use a twodecimal digit precision.
Consider the following time series data.
Week  1  2  3  4  5  6 
Value  18  15  15  13  17  14 
(b)  Develop a threeweek moving average for this time series. Compute MSE and a forecast for week 7.  
If required, round your answers to two decimal places.  


MSE: 5.70  
The forecast for week 7: 14.67 
c)  Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7.  
If required, round your answers to two decimal places.  


MSE: 7.24  
The forecast for week 7: 15.85  
(d)  Compare the threeweek moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE?  
 Select your answer Threeweek moving averageExponential SmoothingItem 15  
Explain.  
The input in the box below will not be graded, but may be reviewed and considered by your instructor.  
(e)  Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.20. Use a twodecimal digit precision.  
alpha: 
Solution:
e)Using trial and error method let us calculate MSE which is smaller.
I have used excel and attached the screenshot below.
From the above table minimum MSE=4.756802 for =0.52
The value of alpha that yields minimum MSE is =0.52
Please give a thumbs up if you are satisfied with the above answer.
Get Answers For Free
Most questions answered within 1 hours.