Question

Calculate the seasonal indices from the following data using the average method:

Year	I Quarter	II Quarter	III Quarter	IV Quarter
2008	72	68	62	76
2009	78	74	78	72
2010	74	70	72	76
2011	76	74	74	72
2012	72	72	76	68

Answer 1

Computation of Seasonal Index by the method of simple averages

Year	I Quarter	II Quarter	III Quarter	IV Quarter
2008	72	68	62	76
2009	78	74	78	72
2010	74	70	72	76
2011	76	74	74	72
2012	72	72	76	68

Grand Average = `("Sum of"  4  "Quarterly Averages")/4`

= `(74.4 + 71.6 + 72.4 + 72.8)/4`

= `291.2/4`

= 72.8

S.I for I Quarter = `"Average of I Quarter"/"Grand Average" xx 100`

= `74.4/72.8 xx 100`

= 102.20

S.I for II Quarter = `"Average of II Quarter"/"Grand Average" xx 100`

= `71.6/72.8 xx 100`

= 98.35

S.I for III Quarter = `"Average of III Quarter"/"Grand Average" xx 100`

= `72.4/72.8 xx 100`

= 99.45

S.I for IV Quarter = `"Average of IV Quarter"/"Grand Average" xx 100`

= `72.8/72.8 xx 100`

= 100