Share
Explore BrainMass

Moving average

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 15 most recent terms are shown in the middle column of the table below. A time series plot of the data was included in the question. In the far-right column of the table are the 5-term moving averages for the data. Fill in both missing blanks in this column. Round your answer to at least 2 decimal places.

Term Enrollment (in thousands) 5-Term Moving average
1 23.3 NA
2 22.4 NA
3 24.4 24.78
4 26.2 25.88
5 27.6 26.96
6 28.8 28.26
7 27.8 29.44
8 30.9 30.28
9 32.1 31.00
10 31.8 ?
11 32.4 32.82
12 32.5 ?
13 35.3 35.00
14 36.9 NA
15 37.9 NA

Solution Summary

The solution provides step by step method for the calculation of moving average . Formula for the calculation and Interpretations of the results are also included.

$2.19