The work is to Compute moving average and weighted moving average in a time-series model. The 1 question is below:

1. Determine which of the two forecasts should be chosen and give the rationale for the decision.

DATA:

3-Month Moving Average - forecast is $36,000.00

Number Analysis of Forecast Error of Periods Averaged 3 MAD MSE MAPE 8333.33333 101622222.22222 18.53931% Data Formulas cells in column to the right need a average Number of absolute percentage weighted Formula to Period Number Data formula forecast error value of error | squared error error periods copy 46,000 48,000 46000.00000 51,000 47000.00000 64,000 Formula Needed -> 48333.33333 3 48333.33333 62,000 Formula Needed -> 54333.33333 52250.00000 63,000 Formula Needed -> 59000.00000 54200.00000 57,000 Formula Needed -> 63000.00000 55666.66667 55,000 Formula Needed -> 60666.66667 55857.14286 52,000 Formula Needed -> 58333.33333 55750.00000 56,000 Formula Needed -> 54666.66667 55333.33333 38,000 Formula Needed -> 54333.33333 55400.00000 31,000 Formula Needed -> 48666.66667 53818.18182 39,000 Formula Needed -> 41666.66667 51916.66667 Formula Needed -> 36000.00000Analysis of Forecast Error Number of Periods 3 MAD MSE MAPE 7300.00000 84187500.00000 16.445 43% Data Formulas Weighted Indicates which moving cells in column to Number of Period the right need a average absolute value of percentage weighted number data weight formula forecast error error squared error error periods Formula to copy 46,000 1 48,000 3 46000.00 00 0 51,000 47500.00 000 64,000 Formula Needed -> 49250.00 000 3 49250.00 00 0 62,000 Formula Needed -3 57125.00 000 49250.00 00 0 63,000 Formula Needed -> 61375.00 000 49250.00 00 0 57,000 Formula Needed -> 62750.00 000 49 250.00 00 0 55,000 Formula Needed -> 59875.00 000 49250.00 00 0 52,000 Formula Needed 56750.00 000 49250.00 00 0 JIIIIIIII 56,000 Formula Needed 53750.00 000 49250.00 00 0 38,000 Formula Needed -> 54375.00 000 49250.00 00 0 31,000 Formula Needed -> 465 00.00 00 0 49250.00 00 0 39,000 Formula Needed -> 36750.00 000 49250.00 00 0 Formula Needed -> 35875.00 00 0