Advertisements
Advertisements
प्रश्न
Solve the following problem :
Fit a trend line to data in Problem 4 by the method of least squares.
Advertisements
उत्तर
In the given problem, n = 12 (odd), middle t – value is 1976, h = 1
u = `"t - middle value"/("h"/2) = ("t" - 1976.5)/(1/2)` = 2(t – 1976.5)
We obtain the following table.
| Year t |
Production yt |
u = 2(t – 1976.5) | u2 | uyt | Trend Value |
| 1971 | 1 | –11 | 121 | –11 | 0.0900 |
| 1972 | 0 | –9 | 81 | 0 | 0.6494 |
| 1973 | 1 | –7 | 49 | –7 | 1.2088 |
| 1974 | 2 | –5 | 25 | –10 | 1.7682 |
| 1975 | 3 | – | 9 | –9 | 2.3276 |
| 1976 | 2 | –1 | 1 | –2 | 2.8870 |
| 1977 | 3 | 1 | 1 | 3 | 3.4464 |
| 1978 | 6 | 3 | 9 | 18 | 4.0058 |
| 1979 | 5 | 5 | 25 | 25 | 4.5652 |
| 1980 | 1 | 7 | 49 | 7 | 5.1246 |
| 1981 | 4 | 9 | 81 | 36 | 5.6840 |
| 1982 | 10 | 11 | 121 | 110 | 6.243 |
| Total | 38 | 0 | 572 | 160 |
From the table, n = 12, `sumy_"t" = 38, sumu = 0, sumu^2 = 572,sumuy_"t" = 160`
The two normal equations are: `sumy_"t" = "na"' + "b"' sumu "and" sumuy_"t", = a'sumu + b'sumu^2`
∴ 38 = 12a' + b'(0) ...(i) and
160 = a'(0) + b'(572) ...(ii)
From (i), a' = `(38)/(12)` = 3.1667
From (ii), b' = `(160)/(572)` = 0.2797
∴ The equation of the trend line is yt = a' + b'u
i.e., yt = 3.1667 + 0.2797 u, where u = 2(t – 1976.5).
APPEARS IN
संबंधित प्रश्न
Obtain the trend line for the above data using 5 yearly moving averages.
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 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.
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 :
Obtain trend values for the following data using 5-yearly moving averages.
| 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 the data in Problem 7 by the method of least squares.
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 :
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.
Solve the following problem :
Fit a trend line to data in Problem 16 by the method of least squares.
Solve the following problem :
Obtain trend values for data in Problem 16 using 3-yearly moving averages.
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 ______
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
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 |
Use the method of least squares to fit a trend line to the data given below. Also, obtain the trend value for the year 1975.
| 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 | 8 | 9 | 9 | 8 | 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 |
| 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.
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 | – | – |
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 | – | – |
The complicated but efficient method of measuring trend of time series is ______.
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.
