Course 7.3Lesson 2 of 3
Quarterly data have a cycle of four. A 4-point moving average lands between two quarters, so it cannot be compared with a real value. Centring fixes this. Then a trend line drawn by eye through the moving averages shows where the series is heading.
Try the code and the simulations beside the lesson.
A made-up museum counts its visitors, in thousands, in each quarter of the year. Quarter 1 is January to March.
| Year | Quarters 1 and 2 | Quarters 3 and 4 |
|---|---|---|
| 1 | 38, 56 | 64, 42 |
| 2 | 46, 64 | 72, 50 |
| 3 | 50, 76 | 80, 58 |
Number the quarters to . Quarter 3 is the busiest every year, and quarter 1 the quietest. The cycle has four quarters, so we use a 4-point moving average.
The first average uses quarters 1, 2, 3 and 4: .
The middle of quarters 1, 2, 3 and 4 is halfway between quarter 2 and quarter 3, at . The next average, , sits at .
The nine 4-point moving averages are 50, 52, 54, 56, 58, 59, 62, 64 and 66, at .
None of these sits on a real quarter. To compare an average with a real value, we need one at a quarter. We take the mean of each pair of neighbours.
These are the centred moving averages. The eight of them, for quarters 3 to 10, are 51, 53, 55, 57, 58.5, 60.5, 63 and 65.
When is centring needed? When the number of points is even (4 quarters, 12 months, 6 days), the averages fall between times, so we centre them. When it is odd (3 terms, 7 days), each average already sits on a real time, so no centring is needed.
Plot the centred moving averages on the time series graph. They lie close to a straight line. Draw the trend line by eye: a ruler line that follows the moving averages, with about as many points above it as below it. Do not join the averages point to point, and do not draw it through the data values.
Here a good trend line passes through about and . It rises thousand over 7 quarters, which is 2 thousand visitors a quarter. Its equation is .
Two people may draw slightly different lines by eye. In a question, you may be told two points that the line passes through, so that everyone gets the same answer.
The program works out the 4-point moving averages of the museum data, centres them, and prints the quarter of each centred value.
Your turn.
Try each one on your own first. If you are stuck, open a hint. Then check with Show the answer.
Every lesson is open to read. Enrolling also lets you:
Log in to join the discussion.
Loading…
This lesson is free to read. Enroll free to keep your place and take the tests.