Lesson 3: Smoothing with moving means and medians

Smooth water-use data with a 3-point moving mean

SkillMoving means

Worked example

  • Simple familiar

Mean daily water use per person (litres) in a south-east Queensland town is shown. Data are illustrative.

Year2015201620172018201920202021202220232024
Water use (L)182176179171168170163160162155

a) Calculate the 3-point moving means for 2016, 2017 and 2018, correct to two decimal places.

b) The years are in cells A2 to A11 and the water use in B2 to B11 of a spreadsheet. Write the formula for the 3-point moving mean for 2016, and say where it goes.

1 of 4 steps
  1. Step 1: Find the first window

    A 3-point window has one value either side of the middle, so 2016's window is 2015, 2016 and 2017. There is no moving mean for 2015, because it has no value before it.

Try a similar one

A fresh question of the same kind, checked as you answer, with hints and a full solution.

Method

  1. Centre a window of kk values on the period.

  2. Average them and place the result at the middle period.

  3. Move the window on one period and repeat. In a spreadsheet, fill the formula down.

Watch out for

  • Putting the 2015–2017 average next to 2015 (or 2017) instead of 2016.

  • Calculating a value for 2015 or 2024: the end periods have no 3-point moving mean.

Save your progress with a free account