Question

The number of road accidents in the city due to rash driving, over a period of 3 years, is given in the following table:

Year	Jan-March	April-June	July-Sept.	Oct.-Dec.
2010	70	60	45	72
2011	79	56	46	84
2012	90	64	45	82

Calculate four quarterly moving averages and illustrate them and original figures on one graph using the same axes for both.

Answer 1

Year/Quarters	Road Accidents	4 quarterly moving total	4 quarterly moving average
`{:(I), (II), (III), (IV):}}2010`	70 60 45 72	247 256	61.75 64

 

Year/Quarters	Road Accidents	4 quarterly moving total	4 quarterly moving average
`{:(I), (II), (III), (IV):}}2011`	79 56 46 84	252 253 265 276	63 63.25 66.25 69
`{:(I), (II), (III), (IV):}}2012`	90 64 45 82	284 283 281	71 70.75 70.25