Suppose you are given the following data. You have run a three month moving average and...

Transcribed Image Text:

Suppose you are given the following data. You have run a three month moving average and found the forecasts, difference, and difference squared between the demand and forecasts. Note, the forecasts, difference, and difference squared have been rounded to two decimal places in the table. Month June Time 1 Actual Demand Forecast 193 Difference Difference Squared July 12 August 23 96 3 96 September 4 83 95.00 -12.00 144.00 October 5 94 91.67 2.33 5.44 November 6 94 91.00 3.00 9.00 December 7 87 90.33 -3.33 11.11 January 8 97 91.67 5.33 28.44 February 9 86 92.67 -6.67 44.44 March 10 93 90.00 3.00 9.00 April 11 89 92.00 -3.00 9.00 May 12 99 89.33 9.67 93.44 Determine the MSE (mean squared error). 29.49 39.32 353.87 93.44 13 Suppose you are given the following data. You have run a three month moving average and found the forecasts, difference, and difference squared between the demand and forecasts. Note, the forecasts, difference, and difference squared have been rounded to two decimal places in the table. Month June Time 1 Actual Demand Forecast 193 Difference Difference Squared July 12 August 23 96 3 96 September 4 83 95.00 -12.00 144.00 October 5 94 91.67 2.33 5.44 November 6 94 91.00 3.00 9.00 December 7 87 90.33 -3.33 11.11 January 8 97 91.67 5.33 28.44 February 9 86 92.67 -6.67 44.44 March 10 93 90.00 3.00 9.00 April 11 89 92.00 -3.00 9.00 May 12 99 89.33 9.67 93.44 Determine the MSE (mean squared error). 29.49 39.32 353.87 93.44 13