Refer to the DJIA data in Problem 5-37. (a) Use an exponential smoothing model with a smoothing constant of 0.4 to predict the opening DJIA index value for 2011. Find the MSE for this. (b) Use QM for...

Refer to the DJIA data in Problem 5-37.
(a) Use an exponential smoothing model with a smoothing constant of 0.4 to predict the opening DJIA index value for 2011. Find the MSE for this.
(b) Use QM for Windows or Excel and find the smoothing constant that would provide the lowest MSE.