[Solution] University officials at a major university would like to use 5 -term moving averages to analyze enrollment. Enrollment data (in thousands of
Question: University officials at a major university would like to use 5 -term moving averages to analyze enrollment. Enrollment data (in thousands of students) for the 13 most recent terms are shown in the middle column of the table below. Also shown is a time series plot of the data.
In the far-right column of the table are the 5 -term moving averages for the data. Fill in both blanks in this column. Round your responses to at least two decimal places.
Data for Excel
| 1 | 27.7 |
| 2 | 28.3 |
| 3 | 28 |
| 4 | 26.6 |
| 5 | 32.3 |
| 6 | 32.1 |
| 7 | 34.1 |
| 8 | 34.4 |
| 9 | 32.7 |
| 10 | 37.1 |
| 11 | 38.4 |
| 12 | 38.8 |
| 13 | 39.7 |
Deliverable: Word Document 