Page 293 - DECO504_STATISTICAL_METHODS_IN_ECONOMICS_ENGLISH

Statistical Methods in Economics

Notes Table 7: Computation of Ratio-to-Moving Averages to Quarterly Sales Data of Table 6

Year Quarter Actual Centred Centred Ratio-to
sales 4-quarter 4-quarter moving
moving moving average in
total average percentage
1975 I 5.5
II 5.4
III 7.2 23.8 6.0 120.0
IV 6.0 23.5 5.9 101.7
1976 I 4.8 23.2 5.8 82.8
II 5.6 22.5 5.6 100.0
III 6.3 21.9 5.5 114.5
IV 5.6 21.9 5.5 101.8
1977 I 4.0 22.6 5.7 70.2
II 6.3 23.4 5.9 06.8
III 7.0 24.4 6.1 114.8
IV 6.5 25.1 6.3 103.2
1978 I 5.2 25.5 6.4 81.3
II 6.5 26.1 6.5 100.0
III 7.5 26.8 6.7 111.9
IV 7.2 27.5 6.9 104.3
1979 I 6.0 28.2 7.1 84.5
II 7.0 28.9 7.2 97.2
III 8.4
IV 7.7

Table 8: Computation of Seasonal Indices for Quarterly Sales Data of Table 6.

Quarters

Year I II III IV
1975 — — 120.0 101.7
1976 82.8 100.0 114.5 101.8
1977 70.2 106.8 114.8 103.2
1978 81.3 100.0 111.9 104.3
1979 84.5 97.2 — —
Mean 79.7 101.0 115.3 102.8

Seasonal index 79.9 101.3 115.6 103.2

288 LOVELY PROFESSIONAL UNIVERSITY