Prashnikaप्रश्निका
Code
About
‹ 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:
Year2000200120022003200420052006200720082009
Annual sales in lakhs18222026302224283235

Answer

Answer

3-yearly moving totals and averages (each placed against the middle year):
YearSales (lakhs)3-yearly total3-yearly moving average
200018--
2001226020.00
2002206822.67
2003267625.33
2004307826.00
2005227625.33
2006247424.67
2007288428.00
2008329531.67
200935--
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.