Statistics · Ch 4 — Time Series
Measurement of Trend: The Moving Average Method
Measurement of Trend: The Moving Average Method
Meaning
The moving average method measures trend by replacing each value of the series with the average of itself and a fixed number of neighbouring values, smoothing out short-term (seasonal, cyclical, irregular) fluctuations so the underlying trend becomes visible.
Odd period (e.g., 3-yearly, 5-yearly)
For a -yearly moving average, each trend value is
and it centres automatically on the middle year of each group of three. A -yearly moving average works the same way over five consecutive years.
Even period (e.g., 4-yearly, 6-yearly) — needs centring
When the period is even, a moving total or average of, say, four years falls between two years, not on any single year. A second step — a further -yearly moving average of the moving averages already found — centres each value back onto an actual year:
Short illustration. For five years 2018-2022 with values , the 3-yearly moving averages are:
| Year | Value | 3-yr Total | 3-yr Moving Average (Trend) |
|---|---|---|---|
| 2018 | 12 | — | — |
| 2019 | 15 | 12+15+14 = 41 | 13.67 |
| 2020 | 14 | 15+14+18 = 47 | 15.67 |
| 2021 | 18 | 14+18+20 = 52 | 17.33 |
| 2022 | 20 | — | — |
Merits and limitations
- Merits: simple to calculate, objective (no personal judgement, unlike the freehand graphic method), and automatically eliminates the exact period of any regular cyclical/seasonal swing if the moving-average period matches it. …
The average of a fixed number of consecutive values of a series, recalculated by dropping the oldest and adding the next value, used to smooth short-term fluct …
A further 2-yearly moving average applied to an even-period moving average series, needed because the original averages fall betwee …