Advertisements
Advertisements
Question
Complete the table using 4 yearly moving average method.
| Year | Production | 4 yearly moving total |
4 yearly centered total |
4 yearly centered moving average (trend values) |
| 2006 | 19 | – | – | |
| `square` | ||||
| 2007 | 20 | – | `square` | |
| 72 | ||||
| 2008 | 17 | 142 | 17.75 | |
| 70 | ||||
| 2009 | 16 | `square` | 17 | |
| `square` | ||||
| 2010 | 17 | 133 | `square` | |
| 67 | ||||
| 2011 | 16 | `square` | `square` | |
| `square` | ||||
| 2012 | 18 | 140 | 17.5 | |
| 72 | ||||
| 2013 | 17 | 147 | 18.375 | |
| 75 | ||||
| 2014 | 21 | – | – | |
| – | ||||
| 2015 | 19 | – | – |
Solution
| Year | Production | 4 yearly moving total |
4 yearly centered total |
4 yearly centered moving average (trend values) |
| 2006 | 19 | – | – | |
| – | ||||
| 2007 | 20 | – | – | |
| 72 | ||||
| 2008 | 17 | 142 | 17.75 | |
| 70 | ||||
| 2009 | 16 | 136 | 17 | |
| 66 | ||||
| 2010 | 17 | 133 | 16.625 | |
| 67 | ||||
| 2011 | 16 | 135 | 16.875 | |
| 68 | ||||
| 2012 | 18 | 140 | 17.5 | |
| 72 | ||||
| 2013 | 17 | 147 | 18.375 | |
| 75 | ||||
| 2014 | 21 | – | – | |
| – | ||||
| 2015 | 19 | – | – |
RELATED QUESTIONS
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 |
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 :
What is a disadvantage of the graphical method of determining a trend line?
Fill in the blank :
The method of measuring trend of time series using only averages 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 :
All the three methods of measuring trend will always give the same results.
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 |
Obtain trend values for the following data using 4-yearly centered moving averages.
| Year | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 |
| Production | 1 | 0 | 1 | 2 | 3 | 2 |
| Year | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 |
| Production | 3 | 6 | 5 | 1 | 4 | 10 |
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 by the method of least squares.
| Year | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 |
| Number of boxes (in ten thousands) | 1 | 0 | 3 | 8 | 10 | 4 | 5 | 8 |
Solve the following problem :
Obtain trend values for data in Problem 10 using 3-yearly moving averages.
Solve the following problem :
Obtain trend values for data in Problem 13 using 4-yearly moving averages.
Solve the following problem :
Obtain trend values for data in Problem 16 using 3-yearly moving averages.
Obtain trend values for data in Problem 19 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.
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
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
Following table shows the amount of sugar production (in lac tons) for the years 1971 to 1982
| 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 |
Fit a trend line by the method of least squares
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 |
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
Fit equation of trend line for the data given below.
| Year | Production (y) | x | x2 | xy |
| 2006 | 19 | – 9 | 81 | – 171 |
| 2007 | 20 | – 7 | 49 | – 140 |
| 2008 | 14 | – 5 | 25 | – 70 |
| 2009 | 16 | – 3 | 9 | – 48 |
| 2010 | 17 | – 1 | 1 | – 17 |
| 2011 | 16 | 1 | 1 | 16 |
| 2012 | 18 | 3 | 9 | 54 |
| 2013 | 17 | 5 | 25 | 85 |
| 2014 | 21 | 7 | 49 | 147 |
| 2015 | 19 | 9 | 81 | 171 |
| Total | 177 | 0 | 330 | 27 |
Let the equation of trend line be y = a + bx .....(i)
Here n = `square` (even), two middle years are `square` and 2011, and h = `square`
The normal equations are Σy = na + bΣx
As Σx = 0, a = `square`
Also, Σxy = aΣx + bΣx2
As Σx = 0, b = `square`
Substitute values of a and b in equation (i) the equation of trend line is `square`
To find trend value for the year 2016, put x = `square` in the above equation.
y = `square`
