Advertisements
Advertisements
Question
The annual production of a commodity is given as follows:
| Year | production (in tones) |
| 1995 | 155 |
| 1996 | 162 |
| 1997 | 171 |
| 19988 | 182 |
| 1999 | 158 |
| 2000 | 880 |
| 2001 | 178 |
Fit a straight line trend by the method of least squares
Advertisements
Solution
Computation of trend values by the method of least squares. (ODD years)
| Year (x) | Production (in tones) (Y) |
X = x – 1998 | X2 | XY |
Trend values |
| 1995 | 155 | – 3 | 9 | – 465 | 159.57 |
| 1996 | 162 | – 2 | 4 | – 324 | 162.86 |
| 1997 | 171 | – 1 | 1 | – 171 | 166.14 |
| 1998 | 182 | 0 | 0 | 0 | 169.43 |
| 1999 | 158 | 1 | 1 | 158 | 172.72 |
| 2000 | 180 | 2 | 4 | 360 | 176.00 |
| 2001 | 178 | 3 | 9 | 534 | 179.29 |
| N = 7 | `sum"Y"` = 1186 | `sum"X"` = 0 | `sum"X"^2` = 28 | `sum"XY"` = 92 | `sum"Y"_"t"` = 1186.01 |
a =`(sum"Y")/"N" = 1186/7` = 169.429
b = `(sum"XY")/(sum"X"^2) = 92/28` = 3.286
Therefore, the required equation of the straight-line trend is given by Y = a + bX
i. Y = 169.429 + 3.286 X or Y = 169.429 + 3.286 (x – 1998)
The trends values are obtained by
When x = 1995, Yt = 169.429 + 3.286(1995 – 1998) = 159.57
When x = 1996, Yt = 169.429 + 3.286(1996 – 1998) = 162.86
When x = 1997, Yt = 169.429 + 3.286(1997 – 1998) = 166.14
When x = 1998, Yt = -169.429 + 3.286(1998 – 1998) = 169.43
When x = 1999, Yt = 169.429 + 3.286(1999 – 1998) = 172.72
When x = 2000, Yt = 169.429 + 3.286(2000 – 1998) = 176.00
When x = 2001, Yt = 169.429 + 3.286(2001 – 1998) = 179.29
APPEARS IN
RELATED QUESTIONS
Define Time series
Mention the components of the time series
Explain the method of fitting a straight line
Determine the equation of a straight line which best fits the following data
| Year | 2000 | 2001 | 2002 | 2003 | 2004 |
| Sales (₹ '000) | 35 | 36 | 79 | 80 | 40 |
Compute the trend values for all years from 2000 to 2004
The sales of a commodity in tones varied from January 2010 to December 2010 as follows:
| In Year 2010 | Sales (in tones) |
| Jan | 280 |
| Feb | 240 |
| Mar | 270 |
| Apr | 300 |
| May | 280 |
| Jun | 290 |
| Jul | 210 |
| Aug | 200 |
| Sep | 230 |
| Oct | 200 |
| Nov | 230 |
| Dec | 210 |
Fit a trend line by the method of semi-average
Use the method of monthly averages to find the monthly indices for the following data of production of a commodity for the years 2002, 2003 and 2004
| 2002 | 2003 | 2004 |
| 15 | 20 | 18 |
| 18 | 18 | 25 |
| 17 | 16 | 21 |
| 19 | 13 | 11 |
| 16 | 12 | 14 |
| 20 | 15 | 16 |
| 21 | 22 | 19 |
| 18 | 16 | 20 |
| 17 | 18 | 1 |
| 15 | 20 | 16 |
| 14 | 17 | 18 |
| 18 | 15 | 20 |
Choose the correct alternative:
The seasonal variation means the variations occurring with in
Using three yearly moving averages, Determine the trend values from the following data.
| Year | Profit | Year | Profit |
| 2001 | 142 | 2007 | 241 |
| 2002 | 148 | 2008 | 263 |
| 2003 | 154 | 2009 | 280 |
| 2004 | 146 | 2010 | 302 |
| 2005 | 157 | 2011 | 326 |
| 2006 | 202 | 2012 | 353 |
The sum of the series `log_4 2 - log_8 2 + log_16 2 + ...............` to `oo` is
Sum of n terms of series 1.3 + 3.5 + 5.7 + ______ is
