Case $2($continued$)$

Use exponential smoothing with a smoothing constant of $=\mathrm{.}6$ to smooth the time series. Forecast the closing price for the next trading day. Use manualy calculations and Excel. Find MSE. Please use Excel.

Forecast for the next trading day is $80\mathrm{.}21$

MSE is $\mathrm{.}52$

Forecast for the next trading day is $80\mathrm{.}31$

MSE is $\mathrm{.}55$

Forecast for the next trading day is $80\mathrm{.}31$

MSE is $42(0\mathrm{.}416)$

Non of these alternatives is correct