Question: 4-week moving average forecast for week 13? (round your answer to 2nd decimal digit) Gasoline Sales Actual 3-week Squared 4-week Squared 5-week Squared Week Sales
4-week moving average forecast for week 13? (round your answer to 2nd decimal digit)
| Gasoline Sales | |||||||
| Actual | 3-week | Squared | 4-week | Squared | 5-week | Squared | |
| Week | Sales | Mov. Ave. | Error | Mov. Ave. | Error | Mov. Ave. | Error |
| 1 | 17 | ||||||
| 2 | 21 | ||||||
| 3 | 19 | ||||||
| 4 | 23 | 19.000 | 16.000 | ||||
| 5 | 18 | 21.000 | 9.000 | ||||
| 6 | 16 | 20.000 | 16.000 | ||||
| 7 | 20 | 19.000 | 1.000 | ||||
| 8 | 18 | 18.000 | 0.000 | ||||
| 9 | 22 | 18.000 | 16.000 | ||||
| 10 | 20 | 20.000 | 0.000 | ||||
| 11 | 15 | 20.000 | 25.000 | ||||
| 12 | 22 | 19.000 | 9.000 | ||||
| 13 | ? | 19.000 | |||||
| MSE | 19.25 | 10.222 | |||||
| 19.300 | 10.222 | ||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
