The quarterly sales (in lakh Rs.) of a shop for two years are given below.
| Year | 2023 | 2024 | ||||||
| Quarter | I | II | III | IV | I | II | III | IV |
| Sales (in lakh Rs.) | 20 | 28 | 34 | 22 | 24 | 32 | 38 | 26 |
The 4-quarter centred moving average (in lakh Rs.) for the third quarter of 2023 is
Answer & explanation
Correct answer: option 2
The correct answer is Option (2) → 26.5
A 4-quarter moving average has no middle quarter, so it falls between two quarters. The first two 4-quarter moving averages are
\( \displaystyle \frac{20 + 28 + 34 + 22}{4} = \frac{104}{4} = 26 \) (between quarters II and III of 2023)
\( \displaystyle \frac{28 + 34 + 22 + 24}{4} = \frac{108}{4} = 27 \) (between quarters III and IV of 2023)
Centring takes the mean of these two neighbouring averages, which places it against quarter III of 2023:
\( \displaystyle \frac{26 + 27}{2} = 26.5 \)
Why the other options are incorrect
Option (1) 26 — Incorrect. It is the first 4-quarter moving average before centring; it lies between quarters II and III.
Option (3) 27 — Incorrect. It is the second 4-quarter moving average before centring; it lies between quarters III and IV.
Option (4) 27.5 — Incorrect. It is the centred moving average for quarter IV of 2023, the mean of 27 and the next average 28.