Advertisements
Advertisements
Question
Fit a trend line to the data in Problem 7 by the method of least squares. Also, obtain the trend value for the year 1990.
Advertisements
Solution
In the given problem, n = 11 (odd), middle t- values is 1981, h = 1
u = `"t - middle value"/"h" = ("t" - 1981)/(1)` = t – 1981
We obtain the following table.
| Year t |
Production yt |
u = t–1981 | u2 | uyt | Trend Value |
| 1976 | 0 | –5 | 25 | 0 | 1.6819 |
| 1977 | 4 | –4 | 16 | –16 | 2.4728 |
| 1978 | 4 | –3 | 9 | –12 | 3.2637 |
| 1979 | 2 | –2 | 4 | –4 | 4.0546 |
| 1980 | 6 | –1 | 1 | –6 | 4.8455 |
| 1981 | 8 | 0 | 0 | 0 | 5.6364 |
| 1982 | 5 | 1 | 1 | 5 | 6.4273 |
| 1983 | 9 | 2 | 4 | 18 | 7.2182 |
| 1984 | 4 | 3 | 9 | 12 | 8.0091 |
| 1985 | 10 | 4 | 16 | 40 | 8.8 |
| 1986 | 10 | 5 | 25 | 50 | 9.5909 |
| Total | 62 | 0 | 110 | 87 |
From the table, n = 11, `sumy_"t" = 62, sumu = 0, sumu^2 = 110, sumuy_"t" = 87`
The two normal equations are : `sumy_"t" = "na"' + "b"' sumu "and" sumuy_"t" = "a"' sumu + "b"'sumu^2`
∴ 62 = 11a' + b'(0) ...(i) and
87 = a'(0) + b'(110) ...(ii)
From (i), a' = `(62)/(11)` = 5.6364
From (ii), b' = `(87)/(110)` = 0.7909
∴ The equation of the trend line is yt = a' + b'u
i.e., yt = 5.6364 + 0.7909 u, where u = t – 1981
∴ Now, For t = 1990, u = 1990 – 1981= 9
∴ yt = 5.6364 + 0.7909 x 9 = 12.7545.
APPEARS IN
RELATED QUESTIONS
Obtain the trend values for the above data using 3-yearly moving averages.
Choose the correct alternative :
We can use regression line for past data to forecast future data. We then use the line which_______.
Choose the correct alternative :
Which of the following is a major problem for forecasting, especially when using the method of least squares?
Fill in the blank :
The complicated but efficient method of measuring trend of time series is _______.
Solve the following problem :
The following table shows the production of pig-iron and ferro- alloys (‘000 metric tonnes)
| Year | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 |
| Production | 0 | 4 | 9 | 9 | 8 | 5 | 4 | 8 | 10 |
Fit a trend line to the above data by graphical method.
Fit a trend line to the following data by the method of least squares.
| Year | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 |
| Production | 0 | 4 | 9 | 9 | 8 | 5 | 4 | 8 | 10 |
Solve the following problem :
Fit a trend line to data in Problem 4 by the method of least squares.
Solve the following problem :
The percentage of girls’ enrollment in total enrollment for years 1960-2005 is shown in the following table.
| Year | 1960 | 1965 | 1970 | 1975 | 1980 | 1985 | 1990 | 1995 | 2000 | 2005 |
| Percentage | 0 | 3 | 3 | 4 | 4 | 5 | 6 | 8 | 8 | 10 |
Fit a trend line to the above data by graphical method.
Solve the following problem :
Obtain trend values for data in Problem 10 using 3-yearly moving averages.
Solve the following problem :
Following table shows the number of traffic fatalities (in a state) resulting from drunken driving for years 1975 to 1983.
| Year | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 |
| No. of deaths | 0 | 6 | 3 | 8 | 2 | 9 | 4 | 5 | 10 |
Fit a trend line to the above data by graphical method.
Solve the following problem :
Fit a trend line to data in Problem 13 by the method of least squares.
Solve the following problem :
Following table shows the all India infant mortality rates (per ‘000) for years 1980 to 2010.
| Year | 1980 | 1985 | 1990 | 1995 | 2000 | 2005 | 2010 |
| IMR | 10 | 7 | 5 | 4 | 3 | 1 | 0 |
Fit a trend line to the above data by graphical method.
Solve the following problem :
Obtain trend values for data in Problem 16 using 3-yearly moving averages.
Solve the following problem :
Following tables shows the wheat yield (‘000 tonnes) in India for years 1959 to 1968.
| Year | 1959 | 1960 | 1961 | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 |
| Yield | 0 | 1 | 2 | 3 | 1 | 0 | 4 | 1 | 2 | 10 |
Fit a trend line to the above data by the method of least squares.
Choose the correct alternative:
Moving averages are useful in identifying ______.
State whether the following statement is True or False:
The secular trend component of time series represents irregular variations
State whether the following statement is True or False:
Least squares method of finding trend is very simple and does not involve any calculations
Obtain the trend values for the data, using 3-yearly moving averages
| Year | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 |
| Production | 0 | 4 | 4 | 2 | 6 | 8 |
| Year | 1982 | 1983 | 1984 | 1985 | 1986 | |
| Production | 5 | 9 | 4 | 10 | 10 |
Following table shows the all India infant mortality rates (per ‘000) for years 1980 to 2010
| Year | 1980 | 1985 | 1990 | 1995 |
| IMR | 10 | 7 | 5 | 4 |
| Year | 2000 | 2005 | 2010 | |
| IMR | 3 | 1 | 0 |
Fit a trend line by the method of least squares
Solution: Let us fit equation of trend line for above data.
Let the equation of trend line be y = a + bx .....(i)
Here n = 7(odd), middle year is `square` and h = 5
| Year | IMR (y) | x | x2 | x.y |
| 1980 | 10 | – 3 | 9 | – 30 |
| 1985 | 7 | – 2 | 4 | – 14 |
| 1990 | 5 | – 1 | 1 | – 5 |
| 1995 | 4 | 0 | 0 | 0 |
| 2000 | 3 | 1 | 1 | 3 |
| 2005 | 1 | 2 | 4 | 2 |
| 2010 | 0 | 3 | 9 | 0 |
| Total | 30 | 0 | 28 | – 44 |
The normal equations are
Σy = na + bΣx
As, Σx = 0, a = `square`
Also, Σxy = aΣx + bΣx2
As, Σx = 0, b =`square`
∴ The equation of trend line is y = `square`
Obtain trend values for data, using 3-yearly moving averages
Solution:
| Year | IMR | 3 yearly moving total |
3-yearly moving average (trend value) |
| 1980 | 10 | – | – |
| 1985 | 7 | `square` | 7.33 |
| 1990 | 5 | 16 | `square` |
| 1995 | 4 | 12 | 4 |
| 2000 | 3 | 8 | `square` |
| 2005 | 1 | `square` | 1.33 |
| 2010 | 0 | – | – |
Following table shows the amount of sugar production (in lakh tonnes) for the years 1931 to 1941:
| Year | Production | Year | Production |
| 1931 | 1 | 1937 | 8 |
| 1932 | 0 | 1938 | 6 |
| 1933 | 1 | 1939 | 5 |
| 1934 | 2 | 1940 | 1 |
| 1935 | 3 | 1941 | 4 |
| 1936 | 2 |
Complete the following activity to fit a trend line by method of least squares:
The following table shows gross capital information (in Crore ₹) for years 1966 to 1975:
| Years | 1966 | 1967 | 1968 | 1969 | 1970 |
| Gross Capital information | 20 | 25 | 25 | 30 | 35 |
| Years | 1971 | 1972 | 1973 | 1974 | 1975 |
| Gross Capital information | 30 | 45 | 40 | 55 | 65 |
Obtain trend values using 5-yearly moving values.
The publisher of a magazine wants to determine the rate of increase in the number of subscribers. The following table shows the subscription information for eight consecutive years:
| Years | 1976 | 1977 | 1978 | 1979 |
| No. of subscribers (in millions) |
12 | 11 | 19 | 17 |
| Years | 1980 | 1981 | 1982 | 1983 |
| No. of subscribers (in millions) |
19 | 18 | 20 | 23 |
Fit a trend line by graphical method.
