Problem 15-00 (Algorithmic) Reter again to the gasoline sales time series cata in the following table Weat Sales (1000s of gallons) 12 1 Z 22 3 211 4 25 5 12 5 17 7 20 19 y 9 23 10 21 13 11 12 21 a. Using a weight of 1/2 for tive most recent abservation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-wack waig ved moving average for the time series. Use ourded for twa decimal places values for intamadata calators. Use minus sign for negative values. Weighted Moving Average Forecast Forecast Error (Error)2 Week Sales 1 1 13 2 2 22 20 4 25 25 20.17 -4.83 x 23.30 X 34.03 x 5 17 22.83 5.83 x 17 E 20.17 10.03 X 3.17 x SIM -1.67 X 7 20 18.33 2.78 x 19 18.5 0.25 0.5 . -4.00 X -4.00 5 23 19.00 0.25 x 10 21 21.17 -0.17 0.03 11 13 21.33 2.33 X 5.44 X 12 24 20.33 X -3.67 X 13.44 X 105.36 X h. Compute te HSE for the weighted moving average in aarta. Do you prefer this weighted moving average to the unweighted moving average? Remember that the MSE for the weig ved moving average is 10.22. Round your answer ta ta decimal places. MSE - 11.71 x Prefer the unweighted moving average here. Suppuse you are allowed to those weights as long as they sur to 1. Could you always find a set of weights that would make the Staler for a weighted moving sverige this for an unweighted mong sverge? Why ur why not? Theinout in the box below will not be graced, but may be reviewed and considered by your instructor. Problem 15-00 (Algorithmic) Reter again to the gasoline sales time series cata in the following table Weat Sales (1000s of gallons) 12 1 Z 22 3 211 4 25 5 12 5 17 7 20 19 y 9 23 10 21 13 11 12 21 a. Using a weight of 1/2 for tive most recent abservation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-wack waig ved moving average for the time series. Use ourded for twa decimal places values for intamadata calators. Use minus sign for negative values. Weighted Moving Average Forecast Forecast Error (Error)2 Week Sales 1 1 13 2 2 22 20 4 25 25 20.17 -4.83 x 23.30 X 34.03 x 5 17 22.83 5.83 x 17 E 20.17 10.03 X 3.17 x SIM -1.67 X 7 20 18.33 2.78 x 19 18.5 0.25 0.5 . -4.00 X -4.00 5 23 19.00 0.25 x 10 21 21.17 -0.17 0.03 11 13 21.33 2.33 X 5.44 X 12 24 20.33 X -3.67 X 13.44 X 105.36 X h. Compute te HSE for the weighted moving average in aarta. Do you prefer this weighted moving average to the unweighted moving average? Remember that the MSE for the weig ved moving average is 10.22. Round your answer ta ta decimal places. MSE - 11.71 x Prefer the unweighted moving average here. Suppuse you are allowed to those weights as long as they sur to 1. Could you always find a set of weights that would make the Staler for a weighted moving sverige this for an unweighted mong sverge? Why ur why not? Theinout in the box below will not be graced, but may be reviewed and considered by your instructor