‹ Back to the paper
Question 15(b)
5 marks
MathematicsISC 2017 Mathematics Paper 1Short answerApplication of Calculus
Answer the following.
Construct 3 yearly moving averages from the following data and show on a graph against the original…
Construct 3 yearly moving averages from the following data and show on a graph against the original data:
| Year | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 |
|---|---|---|---|---|---|---|---|---|---|---|
| Annual sales in lakhs | 18 | 22 | 20 | 26 | 30 | 22 | 24 | 28 | 32 | 35 |
Answer
Answer
3-yearly moving totals and averages (each placed against the middle year):
Graph: take years on the $x$-axis and sales (lakhs) on the $y$-axis. Plot the original data (18, 22, 20, 26, 30, 22, 24, 28, 32, 35) and join the points, then plot the moving averages for 2001 to 2008 and join them with a smoother line; the moving-average line shows the upward trend.
Hence the 3-yearly moving averages are 20, 22.67, 25.33, 26, 25.33, 24.67, 28 and 31.67.
| Year | Sales (lakhs) | 3-yearly total | 3-yearly moving average |
| 2000 | 18 | - | - |
| 2001 | 22 | 60 | 20.00 |
| 2002 | 20 | 68 | 22.67 |
| 2003 | 26 | 76 | 25.33 |
| 2004 | 30 | 78 | 26.00 |
| 2005 | 22 | 76 | 25.33 |
| 2006 | 24 | 74 | 24.67 |
| 2007 | 28 | 84 | 28.00 |
| 2008 | 32 | 95 | 31.67 |
| 2009 | 35 | - | - |