The yearly sales (in lakh Rs.) of a company are given below.
| Year | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
| Sales (in lakh Rs.) | 24 | 24 | 28 | 28 | 30 | 34 | 34 | 38 |
Using a straight-line trend fitted by the method of least squares, the estimated (trend) sales (in lakh Rs.) for the year 2026 are
Answer & explanation
Correct answer: option 2
The correct answer is Option (2) → 41
There are 8 years (an even number), so the origin is the midpoint of the two middle years 2020 and 2021, that is 2020.5. To avoid fractions take
\( \displaystyle X = \frac{\text{year} - 2020.5}{0.5} \)
so X takes the values −7, −5, −3, −1, 1, 3, 5, 7 and \(\sum X = 0\). For the trend line \(y = a + bX\):
\( \displaystyle a = \frac{\sum y}{n}, \quad b = \frac{\sum Xy}{\sum X^2} \)
The sums are
\(\sum y = 24 + 24 + 28 + 28 + 30 + 34 + 34 + 38 = 240\)
\(\sum Xy = -168 - 120 - 84 - 28 + 30 + 102 + 170 + 266 = 168\)
\(\sum X^2 = 49 + 25 + 9 + 1 + 1 + 9 + 25 + 49 = 168\)
So
\( \displaystyle a = \frac{240}{8} = 30 \)
\( \displaystyle b = \frac{168}{168} = 1 \)
The trend line is \(y = 30 + X\), and X increases by 2 each year. For 2026
\( \displaystyle X = \frac{2026 - 2020.5}{0.5} = 11 \)
\(y = 30 + 11 = 41\)
Why the other options are incorrect
Option (1) 35.5 — Incorrect. This puts X = 2026 − 2020.5 = 5.5 into \(y = 30 + X\); with this line X is counted in half-years, so X = 11 for 2026.
Option (3) 39 — Incorrect. It is the trend value for 2025 (X = 9), not for 2026.
Option (4) 43 — Incorrect. It is the trend value for 2027 (X = 13), not for 2026.