Question

Determine the equation of the straight-line trend.

Answer 1

Step 1: Assign coded time variables (\( t \)) for convenience:
Let \( t = -2, -1, 0, 1, 2, 3 \) for the years 1996 to 2001, respectively.

Step 2: Tabulate the data:
 

Step 3: Use the least squares formula for straight-line trend:

\[ y = a + bt, \]

where:

\[ a = \frac{\sum y}{N}, \quad b = \frac{\sum (t \cdot y)}{\sum t^2}. \]

Substitute the values:

\[ a = \frac{\sum y}{N} = \frac{35.6}{6} = 5.93, \quad b = \frac{\sum (t \cdot y)}{\sum t^2} = \frac{22.4}{19} = 1.18. \]

Step 4: Write the equation:

\[ y = 5.93 + 1.18t. \]

Answer 2

Step 1: Use the trend equation \( y = 5.93 + 1.18t \).

Step 2: Compute the trend values for \( t = -2, -1, 0, 1, 2, 3 \):

\[ \begin{array}{|c|c|c|} \hline \textbf{Year} & t & \textbf{Trend Value (y)} \\ \hline 1996 & -2 & 5.93 + 1.18(-2) = 3.57 \\ 1997 & -1 & 5.93 + 1.18(-1) = 4.75 \\ 1998 & 0 & 5.93 + 1.18(0) = 5.93 \\ 1999 & 1 & 5.93 + 1.18(1) = 7.11 \\ 2000 & 2 & 5.93 + 1.18(2) = 8.29 \\ 2001 & 3 & 5.93 + 1.18(3) = 9.47 \\ \hline \end{array} \]

Step 3: Compute the trend value for 2002 (\( t = 4 \)):

\[ y = 5.93 + 1.18(4) = 10.65. \]

Final Answer:

• Trend values for 1996–2001 are \( 3.57, 4.75, 5.93, 7.11, 8.29, 9.47 \).
• Expected sales trend for 2002 is \( 10.65 \) lakh ₹.

Answer 3

Step 1: Assign \( t \): Let \( t = -3, -2, -1, 0, 1, 2, 3 \) for the years 2004 to 2010.

Step 2: Tabulate the data:

\[ \begin{array}{|c|c|c|c|c|} \hline \textbf{Year} & \textbf{Profit (y)} & t & t^2 & t \cdot y \\ \hline 2004 & 114 & -3 & 9 & -342 \\ 2005 & 130 & -2 & 4 & -260 \\ 2006 & 126 & -1 & 1 & -126 \\ 2007 & 144 & 0 & 0 & 0 \\ 2008 & 138 & 1 & 1 & 138 \\ 2009 & 156 & 2 & 4 & 312 \\ 2010 & 164 & 3 & 9 & 492 \\ \hline \textbf{Total} & 972 & 0 & 28 & 214 \\ \hline \end{array} \]

Step 3: Use the least squares formula:

\[ y = a + bt, \]

where:

\[ a = \frac{\sum y}{N}, \quad b = \frac{\sum (t \cdot y)}{\sum t^2}. \]

Substituting the values:

\[ a = \frac{972}{7} = 138.86, \quad b = \frac{214}{28} = 7.64. \]

Step 4: Write the equation:

\[ y = 138.86 + 7.64t. \]