Advertisements
Advertisements
Question
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 | – | – |
Solution
| Year | IMR | 3 yearly moving total |
3-yearly moving average (trend value) |
| 1980 | 10 | – | – |
| 1985 | 7 | 22 | 7.33 |
| 1990 | 5 | 16 | 5.33 |
| 1995 | 4 | 12 | 4 |
| 2000 | 3 | 8 | 2.67 |
| 2005 | 1 | 4 | 1.33 |
| 2010 | 0 | – | – |
APPEARS IN
RELATED QUESTIONS
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.
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.
Fill in the blank :
The method of measuring trend of time series using only averages is _______
State whether the following is True or False :
Graphical method of finding trend is very complicated and involves several calculations.
State whether the following is True or False :
Moving average method of finding trend is very complicated and involves several calculations.
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 :
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 :
Obtain trend values for data in Problem 13 using 4-yearly moving averages.
Solve the following problem :
Fit a trend line to data in Problem 16 by the method of least squares.
Choose the correct alternative:
Moving averages are useful in identifying ______.
The method of measuring trend of time series using only averages is ______
Obtain trend values for data, using 4-yearly centred moving averages
| Year | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 |
| Production | 1 | 0 | 1 | 2 | 3 | 2 |
| Year | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 |
| Production | 4 | 6 | 5 | 1 | 4 | 10 |
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 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:
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`
