Try it on paper first. A hint, the key idea and the worked solution are here when you need them.
For the bicycle sales of the last problem, a trend line is drawn by eye through the centred moving averages. It passes through and , where is the quarter number. Find the rise of the trend each quarter and the equation of the trend line in the form . What trend value does the line give for quarter 9?
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 slope. bicycles a quarter.
Step 2. The intercept. , so we want : .
Step 3. Quarter 9. .
Answer: a rise of a quarter, , and a trend value of at quarter 9.
Watch out. Quarter 9 is beyond the data. The value comes from extending the line, which assumes the trend carries on.
Log in to join the discussion.
Loading…