1. Fill out the two column (Moving average 4 cells) | ||||
2. and the center moving average | ||||
Quarter Data for Car Sales | ||||
Year | Quarter | Sales (1000's) | Moving average (4) | Center moving average (baseline) |
year 1 | 1 | 4.8 | ||
2 | 4.1 | |||
3 | 6 | |||
4 | 6.5 | |||
Year 2 | 1 | 5.8 | ||
2 | 5.2 | |||
3 | 6.8 | |||
4 | 7.4 | |||
Year 3 | 1 | 6 | ||
2 | 5.6 | |||
3 | 7.5 | |||
4 | 7.8 | |||
Year 4 | 1 | 6.3 | ||
2 | 5.9 | |||
3 | 8 | |||
4 | 8.4 |
Get Answers For Free
Most questions answered within 1 hours.