onsider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week. Sales (1000s of gallons) 1 16 2. 22 3. 18 4. 23 5. 18 6. 17 7 21 8 17 9 21 10. 21 11 14 12 23
Consider the following gasoline sales time series data. Click on the datafile logo to reference the data.
Week. Sales (1000s of gallons)
1 16
2. 22
3. 18
4. 23
5. 18
6. 17
7 21
8 17
9 21
10. 21
11 14
12 23
Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and third the most recent observation, 1/6 compute a three-week weighted moving average for the time series (to 2 decimals). Enter negative values as negative numbers.
Week |
Time-Series Value |
Weighted Moving Average Forecast |
Forecast Error |
(Error)2 |
||
Total |
b. Compute the MSE for the weighted moving average in part (a).
MSE =
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images