- Calculate the 3-month moving average and MSE
a. Exponentially smooth the data and MSE
b. Explain which method produces better results and why
c. Forecast the value for period 13 using the better method
Dear student, please refer to the attachment for the workings and solutions.
a) Refer to the attachment 'Solution.xlsx' for the ...
A 3-Month Simple Moving Average Forecast and an Exponentially Smoothed Moving Average Forecast has been performed in EXCEL. Further calculations for Forecast Accuracy Measures (Forecast Error, MSE) has been shown in Excel for the two different Forecast techniques and the two forecasts has been compared using these calculations.