Try it on paper first. A hint, the key idea and the worked solution are here when you need them.
A shop sells bicycles. Its sales in each quarter for two years are these.
Find the five 4-point moving averages and the four centred moving averages. At which quarters are the centred values plotted?
A 4-point moving average sits between two quarters. Centre it by taking the mean of two neighbours:
The trend line is drawn by eye through the moving averages.
Check an answer or open a hint to unlock the worked solution.
Have you tried it?
Work it out on paper first. It is fine to get stuck or make a mistake: that is how we learn. When you are ready, go through the solution one step at a time, and check each step against your own.
Step 1. The 4-point averages. The totals are 680, 700, 720, 740 and 760, so the averages are 170, 175, 180, 185 and 190.
Step 2. Centre them. , then 177.5, 182.5 and 187.5.
Step 3. Where. At quarters 3, 4, 5 and 6: quarters 3 and 4 of year 1 and quarters 1 and 2 of year 2.
Answer: 4-point averages to ; centred averages , , and .
Check. Each total grows by 20, because each quarter of year 2 is 20 more than the same quarter of year 1. So the averages grow by 5 a quarter.
Log in to join the discussion.
Loading…