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
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
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 |
The sales of a commodity in tones varied from January 2010 to December 2010 as follows:
| In Year 2010 | Sales (in tones) |
| Jan | 280 |
| Feb | 240 |
| Mar | 270 |
| Apr | 300 |
| May | 280 |
| Jun | 290 |
| Jul | 210 |
| Aug | 200 |
| Sep | 230 |
| Oct | 200 |
| Nov | 230 |
| Dec | 210 |
Fit a trend line by the method of semi-average
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 is a set of data recorded
Choose the correct alternative:
The components of a time series which is attached to short term fluctuation is
Choose the correct alternative:
The seasonal variation means the variations occurring with in
A bullet of mass m and velocity a is fired into a large block of wood of mass M The final velocity of the system is
Sum of n terms of series 1.3 + 3.5 + 5.7 + ______ is
