Calculate the Mean Square Error (MSE).
Month 1993
January 1.45
February 1.80
March 2.03
April 1.99
May 2.32
June 2.20
July 2.13
August 2.43
September 1.90
October 2.13
November 2.56
December 4.16
Using the chart above I need to:
a. Forecast the month of December using an exponential smoothing with a smoothing constant of 0.25.
b. Calculate the Mean Square Error (MSE).
The solution provides explanations and instructions on how to calculate the Mean Square Error in the attached Excel file.