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
Write a brief note on seasonal variations
Compute the average seasonal movement for the following series
| Year | Quarterly Production | |||
| I | II | III | IV | |
| 2002 | 3.5 | 3.8 | 3.7 | 3.5 |
| 2203 | 3.6 | 4.2 | 3. | 4.1 |
| 2004 | 3.4 | 3.9 | 37 | 4.2 |
| 2005 | 4.2 | 4.5 | 3 | 4.4 |
| 2006 | 3.9 | 4.4 | 4.2 | 4.6 |
Use the method of monthly averages to find the monthly indices for the following data of production of a commodity for the years 2002, 2003 and 2004
| 2002 | 2003 | 2004 |
| 15 | 20 | 18 |
| 18 | 18 | 25 |
| 17 | 16 | 21 |
| 19 | 13 | 11 |
| 16 | 12 | 14 |
| 20 | 15 | 16 |
| 21 | 22 | 19 |
| 18 | 16 | 20 |
| 17 | 18 | 1 |
| 15 | 20 | 16 |
| 14 | 17 | 18 |
| 18 | 15 | 20 |
The following table shows the number of salesmen working for a certain concern:
| Year | 1992 | 1993 | 1994 | 1995 | 1996 |
| No. of salesman |
46 | 48 | 42 | 56 | 52 |
Use the method of least squares to fit a straight line and estimate the number of salesmen in 1997
Choose the correct alternative:
A time series consists of
Choose the correct alternative:
The value of ‘b’ in the trend line y = a + bx is
From the following data, calculate the trend values using fourly moving averages.
| Year | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 |
| Sales | 506 | 620 | 1036 | 673 | 588 | 696 | 1116 | 738 | 663 |
The nth term of the series 2 + 4 + 7 + 11 + ..... is
Sum of n terms of series 1.3 + 3.5 + 5.7 + ______ is
The sum of the series 3.6 + 4.7 + 5.8 + ....... upto (n – 2) terms
