In: Math
I realize similar questions were already asked. These aren't the same questions or the same data set. please also explain how to do this in excel.
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 78, 82, 84, 83, 83, 84, 88, 84, 82, 83, 84, and 83.
1.) Create a three-month moving average forecast against an exponential smoothing forecast with α=.2.
2.) Which forecasting method has the smallest error, use the Mean Square Error (MSE) metric as the measure of model accuracy?
3.) What is the forecast for the 13th month using a three month moving average?