Advertisements
Advertisements
Question
Explain the method of fitting a straight line
Advertisements
Solution
The method of fitting a straight line is as follows
Procedure:
(i) The straight-line trend is represented by the equation Y = a + bX ........(1)
Where Y is the actual value, X is time, a, b are constants.
(ii) The constants ‘a and ‘b’ are estimated by solving the following two normal Equations
`sum"Y"` = na + b `sum"X"` ........(2)
`sum"XY" = "a"sum"X" + "b"sum"X"^2` .........(3)
Where ‘n’ = number of years given in the data.
(iii) By taking the mid-point of the time as the origin, we get `sum"X"` = 0
(iv) When `sum"X"` = 0, the two normal equations reduces to
`sum"Y"` = na + b(0), a `(sum"Y")/"n" = bar"Y"`
`sum"XY"` = a(0) + `"b"sum"X"^2`, b = `(sum"XY")/(sum"X"^2)`
The constant ‘a’ gives the mean of Y and ‘b gives the rate of change (slope),
(v) By substituting the values of ‘a and ‘b’ in the trend equation (1), we get the Line of Best Fit.
APPEARS IN
RELATED QUESTIONS
What is the need for studying time series?
Explain cyclic variations
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
Calculate the seasonal indices from the following data using the average method:
| Year | I Quarter | II Quarter | III Quarter | IV Quarter |
| 2008 | 72 | 68 | 62 | 76 |
| 2009 | 78 | 74 | 78 | 72 |
| 2010 | 74 | 70 | 72 | 76 |
| 2011 | 76 | 74 | 74 | 72 |
| 2012 | 72 | 72 | 76 | 68 |
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
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 |
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 |
Sum of n terms of series 1.3 + 3.5 + 5.7 + ______ is
