Skip to content

Business Mathematics and Statistics · Ch 9 — Applied Statistics (Time Series, Index Numbers, Statistical Quality Control)

Measuring Trend: Method of Moving Averages

2

Measuring Trend: Method of Moving Averages

The method of moving averages measures trend by smoothing out the short-term ups and downs in a series, so that the underlying long-term direction becomes visible. For an odd period (3-yearly, 5-yearly, 7-yearly, ...), a kk-yearly moving average is computed as follows:

  1. Add up the values of the first kk years — this is the first moving total.
  2. Divide that total by kk to get the first moving average, and place it against the middle year of that block of kk years.
  3. Slide the block forward by one year — drop the earliest year's value and add the next year's value — to get the next moving total, and repeat.

Worked Example — 3-yearly moving average. A firm's sales (₹ lakh) over seven years were:

Year2015201620172018201920202021
Sales (₹ lakh)12152124273336

3-yearly moving totals and moving averages:

YearSales3-yearly moving total3-yearly moving average (trend value)
201512——
20161512+15+21=4812+15+21=4848÷3=1648 \div 3 = 16
20172115+21+24=6015+21+24=6060÷3=2060 \div 3 = 20
20182421+24+27=7221+24+27=7272÷3=2472 \div 3 = 24
20192724+27+33=8424+27+33=8484÷3=2884 \div 3 = 28
20203327+33+36=9627+33+36=9696÷3=3296 \div 3 = 32
202136——

Notice two structural features of the method: the trend values (16, 20, 24, 28, 32) rise smoothly and evenly even though the raw sales figures did not, and the first and last years always lose a trend value (here, 2015 and 2021) because a full block of kk years cannot be centred on them — a genuine, honest limitation of the method, not a computational slip.

Figure 1 — Sales vs 3-Yearly Moving Average Trend (2016–2020)
Figure 1 — Sales vs 3-Yearly Moving Average Trend (2016–2020)
…

Definition 6Moving Average Method

A method of measuring trend that replaces each value in a time series with the average of itself and a fixed number of neighbouring values, smoothing o …

Definition 7Moving Total

The sum of kk consecutive values of a time series, used as the numerator when computing a kk-year …