Advertisements
Advertisements
Question
Determine the equation of a straight line which best fits the following data
| Year | 2000 | 2001 | 2002 | 2003 | 2004 |
| Sales (₹ '000) | 35 | 36 | 79 | 80 | 40 |
Compute the trend values for all years from 2000 to 2004
Advertisements
Solution
Computation of trend values by the method of least squares. (ODD years)
| Year (x) |
Sales (y) (₹ 000) |
X = (x - 2002) | X2 | XY | Tred Value (Yt) |
| 2000 | 335 | – 2 | 4 | – 70 | 43.2 |
| 2001 | 36 | – 1 | 1 | – 36 | 48.6 |
| 2002 | 79 | 0 | 0 | 0 | 54 |
| 2003 | 80 | 1 | 1 | 80 | 59.4 |
| 2004 | 40 | 2 | 4 | 80 | 64.8 |
| N = 5 | `sum"Y"` = 270 | `sum"X"` = 0 | `sum"X"^2` = 10 | `sum"XY"` = 54 | `sum"Y""t"` 270 |
a = `(sum"Y")/"n" = 270/5` = 54
b = `(sum"XY")/(sum"X"^2) = 54/10` = 5.4
Therefore, the required equation of the straight line trend is given by
Y = a + bX
Y = 54 + 5.4X
Y = 54 + 5.4(x – 2002)
The trend value can be obtained by when x = 2000
Yt = 54 + 5.4(2000 – 2002)
Y = 54+ 5.4(– 2)
= 54 – 10.8
= 43.2
When x = 2001
Yt = 54 + 5.4(2001 – 2002)
Y = 54 + 5.4(– 1)
= 54 – 5.4
= 48.6
When x = 2002
Yt = 54 + 5.4(2002 – 2002)
V = 54 + 5.4(0)
= 54
When x = 2003
Yt = 54 + 5.4(2003 – 2002)
Y = 54 + 5.4(1)
= 54 + 5.4
= 59.4
When x = 2004
Yt = 54 + 5.4(2004 – 2002)
Y = 54 + 5.4(2)
= 54 + 10.8
= 64.8
APPEARS IN
RELATED QUESTIONS
What is the need for studying time series?
Mention the components of the time series
Define secular trend
Discuss about irregular variation
The following figures relates to the profits of a commercial concern for 8 years
| Year | Profit (₹) |
| 1986 | 15,420 |
| 1987 | 15,470 |
| 1988 | 15,520 |
| 1989 | 21,020 |
| 1990 | 26,500 |
| 1991 | 31,950 |
| 1992 | 35,600 |
| 1993 | 34,900 |
Find the trend of profits by the method of three yearly moving averages
Find the trend of production by the method of a five-yearly period of moving average for the following data:
| Year | Production ('000) |
| 1979 | 126 |
| 1980 | 123 |
| 1981 | 117 |
| 1982 | 128 |
| 1983 | 125 |
| 1984 | 124 |
| 1985 | 130 |
| 1986 | 114 |
| 1987 | 122 |
| 1988 | 129 |
| 1989 | 118 |
| 1990 | 123 |
The following table gives the number of small-scale units registered with the Directorate of Industries between 1985 and 1991. Show the growth on a trend line by the free hand method.
| Year | No. of units (in '000) |
| 195 | 10 |
| 986 | 22 |
| 1987 | 36 |
| 198 | 62 |
| 1989 | 55 |
| 1990 | 0 |
| 1991 | 34 |
| 1992 | 50 |
Choose the correct alternative:
The value of ‘b’ in the trend line y = a + bx is
Choose the correct alternative:
The seasonal variation means the variations occurring with in
Fit a straight line trend by the method of least squares to the following data
| Year | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 |
| Sales | 50.3 | 52.7 | 49.3 | 57.3 | 56.8 | 60.7 | 62.1 | 58.7 |
