Advertisements
Advertisements
Question
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.
Advertisements
Solution
In the given problem, n = 10 (even), two middle t – value are 1963 and 1964, h = 1
u = `"t - mean of two middle values"/("h"/2) = ("t" - 1963.5)/(1/2)` = 2(t – 1963.5)
We obtain the following table.
| Year t |
Yield (in '000 tonnes) yt |
u = 2(t – 1963.5) | u2 | uyt | Trend Value |
| 1959 | 0 | –9 | 81 | 0 | –0.1632 |
| 1960 | 1 | –7 | 49 | –7 | 0.4064 |
| 1961 | 2 | –5 | 25 | –10 | 0.9760 |
| 196 | 3 | –3 | 9 | –9 | 1.5456 |
| 1963 | 1 | –1 | 1 | –1 | 2.1152 |
| 1964 | 0 | 1 | 1 | 0 | 2.6848 |
| 1965 | 4 | 3 | 9 | 12 | 3.2544 |
| 1966 | 1 | 5 | 25 | 5 | 3.8240 |
| 1967 | 2 | 7 | 49 | 14 | 4.3936 |
| 1968 | 10 | 9 | 81 | 90 | 4.9632 |
| Total | 24 | 0 | 330 | 94 |
From the table, n = 10, `sumy_"t" = 24, sumu = 0, sumu^2 = 330,sumuy_"t" = 94`
The two normal equations are: `sumy_"t" = "na"' + "b"' sumu "and" sumuy_"t", = a'sumu + b'sumu^2`
∴ 24 = 10a' + b'(0) ...(i) and
94 = a'(0) + b'(330) ...(ii)
From (i), a' = `(24)/(10)` = 2.4
From (ii), b' = `(94)/(330)` = 0.2848
∴ The equation of the trend line is yt = a' + b'u
i.e., yt = 2.4 + 0.2848 u, where u = 2(t – 1963.5).
APPEARS IN
RELATED QUESTIONS
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 |
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.
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.
State whether the following is True or False :
Least squares method of finding trend is very simple and does not involve any calculations.
State whether the following is True or False :
All the three methods of measuring trend will always give the same results.
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.
Solve the following problem :
Following table shows the amount of sugar production (in lac tonnes) for the years 1971 to 1982.
| Year | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 |
| Production | 1 | 0 | 1 | 2 | 3 | 2 | 3 | 6 | 5 | 1 | 4 | 10 |
Fit a trend line to the above data by graphical method.
Solve the following problem :
Fit a trend line to data in Problem 4 by the method of least squares.
Solve the following problem :
Obtain trend values for the data in Problem 7 using 4-yearly moving averages.
Following data shows the number of boxes of cereal sold in years 1977 to 1984.
| Year | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 |
| No. of boxes in ten thousand | 1 | 0 | 3 | 8 | 10 | 4 | 5 | 8 |
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 :
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.
Choose the correct alternative:
Moving averages are useful in identifying ______.
The complicated but efficient method of measuring trend of time series is ______
The method of measuring trend of time series using only averages is ______
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:
Moving average method of finding trend is very complicated and involves several calculations
State whether the following statement is True or False:
Least squares method of finding trend is very simple and does not involve any calculations
The following table gives the production of steel (in millions of tons) for years 1976 to 1986.
| Year | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 |
| Production | 0 | 4 | 4 | 2 | 6 | 8 | 5 | 9 | 4 | 10 | 10 |
Obtain the trend value for the year 1990
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 |
| Production (million barrels) |
0 | 0 | 1 | 1 | 2 | 3 | 4 | 5 |
| Year | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | |
| Production (million barrels) |
6 | 7 | 8 | 9 | 8 | 9 | 10 |
- Obtain trend values for the above data using 5-yearly moving averages.
- Plot the original time series and trend values obtained above on the same graph.
The complicated but efficient method of measuring trend of time series is ______.
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`
Following table gives the number of road accidents (in thousands) due to overspeeding in Maharashtra for 9 years. Complete the following activity to find the trend by the method of least squares.
| Year | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 |
| Number of accidents | 39 | 18 | 21 | 28 | 27 | 27 | 23 | 25 | 22 |
Solution:
We take origin to 18, we get, the number of accidents as follows:
| Year | Number of accidents xt | t | u = t - 5 | u2 | u.xt |
| 2008 | 21 | 1 | -4 | 16 | -84 |
| 2009 | 0 | 2 | -3 | 9 | 0 |
| 2010 | 3 | 3 | -2 | 4 | -6 |
| 2011 | 10 | 4 | -1 | 1 | -10 |
| 2012 | 9 | 5 | 0 | 0 | 0 |
| 2013 | 9 | 6 | 1 | 1 | 9 |
| 2014 | 5 | 7 | 2 | 4 | 10 |
| 2015 | 7 | 8 | 3 | 9 | 21 |
| 2016 | 4 | 9 | 4 | 16 | 16 |
| `sumx_t=68` | - | `sumu=0` | `sumu^2=60` | `square` |
The equation of trend 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=68,sumu=0,sumu^2=60,sumux_t=-44`
Putting these values in normal equations, we get
68 = 9a' + b'(0) ...(3)
∴ a' = `square`
-44 = a'(0) + b'(60) ...(4)
∴ b' = `square`
The equation of trend line is given by
xt = `square`
