मराठी
महाराष्ट्र राज्य शिक्षण मंडळएचएससी वाणिज्य (इंग्रजी माध्यम) इयत्ता १२ वी

The following table shows the production of gasoline in U.S.A. for the years 1962 to 1976.i. Obtain trend values for the above data using 5-yearly moving averages. ii. Plot the original time series

Advertisements
Advertisements

प्रश्न

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.

बेरीज
Advertisements

उत्तर

i.

Year
t
Production (millions of barrels) yt 5–yearly
moving total
5–yearly moving averages trend value
1962 0
1963 0
1964 1 4 0.8
1965 1 7 1.4
1966 2 11 2.2
1967 3 15 3
1968 4 20 4
1969 5 25 5
1970 6 30 6
1971 7 35 7
1972 8 38 7.6
1973 9 41 8.2
1974 8 44 8.8
1975 9
1976 10

ii.
Taking year on X-axis and production trend on Y-axis, we plot the points for production corresponding to years to get the graph of time series and plot the points for trend values corresponding to years to get the graph of trend as shown in the adjoining figure. Production: 5 yearly moving Average: ---------------

shaalaa.com
Measurement of Secular Trend
  या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
पाठ 4: Time Series - Exercise 4.1 [पृष्ठ ६७]

APPEARS IN

संबंधित प्रश्‍न

Obtain the trend line for the above data using 5 yearly moving averages.


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 _______


State whether the following is True or False :

Moving average method of finding trend is very complicated and involves several calculations.


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 :

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 :

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 :

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 :

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.


Obtain trend values for data in Problem 19 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 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


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

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  

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  

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

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`


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×