Advertisements
Advertisements
प्रश्न
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 |
Advertisements
उत्तर
In the given problem, n = 9 (odd), middle t – value is 1978, h = 1
u = `"t - middle value"/"h" = ("t" - 1978)/(1)` = t – 1978
We obtain the following table.
| Year t |
Production yt |
u = t – 1978 | u2 | uyt | Trend Value |
| 1974 | 0 | –4 | 16 | 0 | 3.8001 |
| 1975 | 4 | –3 | 9 | –12 | 4.4334 |
| 1976 | 9 | –2 | 4 | –18 | 5.0667 |
| 1977 | 9 | –1 | 1 | –9 | 5.7 |
| 1978 | 8 | 0 | 0 | 0 | 6.3333 |
| 1979 | 5 | 1 | 1 | 5 | 6.9666 |
| 1980 | 4 | 2 | 4 | 8 | 7.5999 |
| 1981 | 8 | 3 | 9 | 24 | 8.2332 |
| 1982 | 10 | 4 | 16 | 40 | 8.8665 |
| Total | 57 | 0 | 60 | 38 |
From the table, n = 9, `sumy_"t" = 57, sumu = 0, sumu^2 = 60,sumuy_"t" = 38`
The two normal equations are: `sumy_"t" = "na"' + "b"' sumu "and" sumuy_"t", = a'sumu + b'sumu^2`
∴ 57 = 9a' + b'(0) ...(i) and
38 = a'(0) + b'(60) ...(ii)
From (i), a' = `(57)/(9)` = 6.3333
From (ii), b' = `(38)/(60)` = 0.6333
∴ The equation of the trend line is yt = a' + b' u
i.e., yt = 6.3333 + 0.6333 u, where u = t – 1978.
APPEARS IN
संबंधित प्रश्न
Obtain the trend line for the above data using 5 yearly moving averages.
Fit a trend line to the data in Problem 4 above by the method of least squares. Also, obtain the trend value for the index of industrial production for the year 1987.
Obtain the trend values for the data in using 4-yearly centered moving averages.
| Year | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 |
| Index | 0 | 2 | 3 | 3 | 2 | 4 | 5 | 6 | 7 | 10 |
Obtain the trend values for the above data using 3-yearly moving averages.
The following table shows the production of gasoline in U.S.A. for the years 1962 to 1976.
| Year | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 | 1969 | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 |
| Production (Million Barrels) |
0 | 0 | 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 8 | 9 | 10 |
i. Obtain trend values for the above data using 5-yearly moving averages.
ii. Plot the original time series and trend values obtained above on the same graph.
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?
The simplest method of measuring trend of time series is ______.
Fill in the blank :
The complicated but efficient method of measuring trend of time series is _______.
State whether the following is True or False :
Graphical method of finding trend is very complicated and involves several calculations.
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 the data in Problem 7 using 4-yearly moving averages.
Solve the following problem :
Fit a trend line to data in Problem 13 by the method of least squares.
Solve the following problem :
Obtain trend values for data in Problem 13 using 4-yearly moving averages.
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.
Choose the correct alternative:
Moving averages are useful in identifying ______.
The complicated but efficient method of measuring trend of time series is ______
The simplest method of measuring trend of time series is ______
State whether the following statement is True or False:
The secular trend component of time series represents irregular variations
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 the trend values for the following data using 5 yearly moving averages:
| Year | 2000 | 2001 | 2002 | 2003 | 2004 |
| Production xi |
10 | 15 | 20 | 25 | 30 |
| Year | 2005 | 2006 | 2007 | 2008 | 2009 |
| Production xi |
35 | 40 | 45 | 50 | 55 |
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.
Fit a trend line to the following data by the method of least square :
| Year | 1980 | 1985 | 1990 | 1995 | 2000 | 2005 | 2010 |
| IMR | 10 | 7 | 5 | 4 | 3 | 1 | 0 |
Complete the following activity to fit a trend line to the following data by the method of least squares.
| Year | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 |
| Number of deaths | 0 | 6 | 3 | 8 | 2 | 9 | 4 | 5 | 10 |
Solution:
Here n = 9. We transform year t to u by taking u = t - 1979. We construct the following table for calculation :
| Year t | Number of deaths xt | u = t - 1979 | u2 | uxt |
| 1975 | 0 | - 4 | 16 | 0 |
| 1976 | 6 | - 3 | 9 | - 18 |
| 1977 | 3 | - 2 | 4 | - 6 |
| 1978 | 8 | - 1 | 1 | - 8 |
| 1979 | 2 | 0 | 0 | 0 |
| 1980 | 9 | 1 | 1 | 9 |
| 1981 | 4 | 2 | 4 | 8 |
| 1982 | 5 | 3 | 9 | 15 |
| 1983 | 10 | 4 | 16 | 40 |
| `sumx_t` =47 | `sumu`=0 | `sumu^2=60` | `square` |
The equation of trend line is xt= a' + b'u.
The normal equations are,
`sumx_t = na^' + b^' sumu` ...(1)
`sumux_t = a^'sumu + b^'sumu^2` ...(2)
Here, n = 9, `sumx_t = 47, sumu= 0, sumu^2 = 60`
By putting these values in normal equations, we get
47 = 9a' + b' (0) ...(3)
40 = a'(0) + b'(60) ...(4)
From equation (3), we get a' = `square`
From equation (4), we get b' = `square`
∴ the equation of trend line is xt = `square`
