- Suppose These Cats Show The Number Of Pallons Of Caseline Sold By A Gasoline Distributor In Bennington Vermont Over The 1 (11.06 KiB) Viewed 108 times
or tot the most recent observation is for the second most recent onzervation, and for thiro mest recent observation, compute a three-neck weightes moving average for a) Using a weight of the time series (Round your answers to two decal places) Week Time Series Weighted Moving Valve Average Forecast 1 16 2 20 3 4 17 6 15 2 19 12 21 10 19 11 12 21
(b) Compute the MSE for the weighted moving average in part (a), (Round your answer to two decimal place) MSE Do you prefer this weighted moving average to the unweighted moving average? The MSE for the unweighted moving average is 10:22 The weighted moving average is preferred because it has a smaller MSE compared to the unweighted moving average The mighted moving average is preferred because it has a larger HSE compared to the weighted moving average The unweighted moving average as preferred because it has a smaller MSE compared to the weighted moving average The weighted moving average is preferred because it has a larger MSE compared to the weighted moving average (o suppose you are allowed to choose any weights as long as they sum tot. Could you always find a set of weights that would make the MSEsmaller for a weighted moving average than for an weighted moving average? Why or why not? O No, but you will always be able to make the MSE at least as good as the one for an unweighted average Yes, a weighted moving average always has a smaller MSE than an unweighted moving average No, sometimes you need to let the weights sum to a number Wigher/lower than in order to get a smaller MSE than the one for an unweighted moving average No, an unweighted moving average always has a smaller NSE than a weighted moving average
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000s of gallons) 16 1 2 20 الما 18 4 22 5 5 17 Oh 15 7 19 B 17 on 21 10 19 11 14 12 21
(a) Using a weight of for the most recent observation, for the second most recent observation, and for third most recent observation, compute a three-week weighted moving average for the time series. (Round your answers to two decimal places) Time Series Weighted Moving Average Forecast Week Value 1 16 2 20 3 18 4 22 5 17 6 IS 7 19 17 8 9 21 1 10 19 11 14 12 21
(b) Compute the MSE for the weighted moving average in part (a). (Round your answer to two decimal places.) MSE = Do you prefer this weighted moving average to the unweighted moving average? The MSE for the unweighted moving average is 10.22 The weighted moving average is preferred because it has a smaller MSE compared to the unweighted moving average. The unweighted moving average is preferred because it has a larger MSE compared to the weighted moving average. The unweighted moving average is preferred because it has a smaller MSE compared to the weighted moving average. The weighted moving average is preferred because it has a larger MSE compared to the unweighted moving average. (©) Suppose you are allowed to choose any welghts as long as they sum to 1. Could you always find a set of weights that would make the MSE smaller for a weighted moving average than for an unweighted moving average? Why or why not? O No, but you will always be able to make the MSE at least as good as the one for an unweighted average. Yes, a weighted moving average always has a smaller MSE than an unweighted moving average. No, sometimes you need to let the weights sum to a number higher/lower than 1 In order to get a smaller MSE than the one for an unweighted moving average. No, an unweighted moving average always has a smaller MSE than a weighted moving average.