Work out the trend values by any suitable method from the following data showing the number of murders (in thousand) in a country for the years 1985-1995. Year: 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 Murders: 19.0 | 20.6 | 20.1 | 20.7 | 21.5 | 24.7 | 24.7 | 23.8 | 24.5 | 23.3 | 21.6
Fit a trend by a suitable method (least squares straight line) and give the trend value for each year.
Common trap: With 11 (odd) years, take X = year − 1990 so that ΣX = 0; then a = ΣY/n and b = ΣXY/ΣX². Give every year's trend value, not just the equation.
SyllabusOld-pattern GS Paper II (2006–12): Statistical analysis, graphs and diagrams — time series and trend
Model answer
5 marks · 50-word limitThe method of least squares fits a straight-line trend Y = a + bX; taking the middle year 1990 as origin (X = year − 1990) makes ΣX = 0.
Method / formula
- Normal equations: With ΣX = 0: a = ΣY/n = 244.5/11 = 22.227 and b = ΣXY/ΣX² = 46.4/110 = 0.4218.
- Trend equation: Y = 22.227 + 0.4218X (thousand murders), origin 1990, X in years.
Working and result
| Year | X | Y | Trend value |
|---|---|---|---|
| 1985 | −5 | 19.0 | 20.12 |
| 1986 | −4 | 20.6 | 20.54 |
| 1987 | −3 | 20.1 | 20.96 |
| 1988 | −2 | 20.7 | 21.38 |
| 1989 | −1 | 21.5 | 21.81 |
| 1990 | 0 | 24.7 | 22.23 |
| 1991 | 1 | 24.7 | 22.65 |
| 1992 | 2 | 23.8 | 23.07 |
| 1993 | 3 | 24.5 | 23.49 |
| 1994 | 4 | 23.3 | 23.91 |
| 1995 | 5 | 21.6 | 24.34 |
Murders show a rising trend of about 0.42 thousand (420) a year, though actual values fell after 1991.
Read more — sources
- BookS.P. Gupta, Statistical Methods (Sultan Chand)
- BookS.C. Gupta and V.K. Kapoor, Fundamentals of Applied Statistics — Analysis of Time Series
More from GS Paper II (old) 2010
Model answer by the EdiShorts editorial team. It is one well-argued treatment of the question, written to the official word limit — not an official UPSC answer key.