Calculator Our protection may Print item More Problem 15-08 (Algorithmic) Refer again to the gasoline sales time series data in the following table Sales (1000s of gallons) a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three week weighted moving average for the time series. Use rounded for two decimal places values for intermediate calculations. Useinus sign for negative values Weighted Moving Average Forecast Forecast Error Week Sales (Error) Check My Work a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent compute a three-week weighted moving average for the time series. Use Founded for two decimal places values for intermediate calculations. Use minus sign for negative values Weighted Moving Average Forecast Forecast Error (Error) Week Sales weighted moving average member that the Compute the MSE for the weighted moving average parta. Do you prefer this weed mong average to the MSE for the weighted moving average is 10 22. Round your answer to two decimal places Calculator b. Compute the MSE for the weighted moving average in parta. Do you prefer this wehted moving average to the MSE for the unweighted moving average is 10.22. Round your answer to two decimal places moving member that the MSE Prefer the moving average here h at would make the MSE c. Suppose you are allowed to choose any weights as long as they sum to 1. Could you always finds of w moving average than for an unweighted moving average? Why or why not? The input in the box below will not be graded, but may be reviewed and considered by your instructor aller for a weight Cd My Work Submit A g ent for Grading