Question

the annual profits for a company are given in the following table, where x represents the number of years since 1997, and y represents the profit in thousands of dollars. write the linear regression equation that represents this set of data, rounding all coefficients to the nearest tenth. using this equation, find the projected profit (in thousands of dollars) for 2006, rounded to the nearest thousand dollars.

years since 1997 (x)	profits (y) (in thousands of dollars)
1	168
2	202
3	193
4	221

answer attempt 2 out of 2

regression equation:

final answer: thousand dollars

Explanation:

Step1: Calculate sums

Let \(n = 5\) (number of data - points).
\(\sum_{i = 1}^{n}x_{i}=0 + 1+2 + 3+4=10\)
\(\sum_{i = 1}^{n}y_{i}=131 + 168+202+193+221 = 915\)
\(\sum_{i = 1}^{n}x_{i}^{2}=0^{2}+1^{2}+2^{2}+3^{2}+4^{2}=0 + 1+4 + 9+16 = 30\)
\(\sum_{i = 1}^{n}x_{i}y_{i}=0\times131+1\times168 + 2\times202+3\times193+4\times221=0 + 168+404+579+884 = 2035\)

Step2: Calculate slope \(m\)

The formula for the slope \(m\) of the regression line \(y=mx + b\) is \(m=\frac{n\sum_{i = 1}^{n}x_{i}y_{i}-\sum_{i = 1}^{n}x_{i}\sum_{i = 1}^{n}y_{i}}{n\sum_{i = 1}^{n}x_{i}^{2}-(\sum_{i = 1}^{n}x_{i})^{2}}\)
Substitute \(n = 5\), \(\sum_{i = 1}^{n}x_{i}=10\), \(\sum_{i = 1}^{n}y_{i}=915\), \(\sum_{i = 1}^{n}x_{i}^{2}=30\), \(\sum_{i = 1}^{n}x_{i}y_{i}=2035\) into the formula:
\[

$$\begin{align*} m&=\frac{5\times2035-10\times915}{5\times30 - 10^{2}}\\ &=\frac{10175-9150}{150 - 100}\\ &=\frac{1025}{50}\\ & = 20.5 \end{align*}$$

\]

Step3: Calculate y - intercept \(b\)

The formula for the y - intercept \(b\) is \(b=\frac{\sum_{i = 1}^{n}y_{i}-m\sum_{i = 1}^{n}x_{i}}{n}\)
Substitute \(n = 5\), \(\sum_{i = 1}^{n}x_{i}=10\), \(\sum_{i = 1}^{n}y_{i}=915\), \(m = 20.5\) into the formula:
\[

$$\begin{align*} b&=\frac{915-20.5\times10}{5}\\ &=\frac{915 - 205}{5}\\ &=\frac{710}{5}\\ &=142 \end{align*}$$

\]

The regression equation is \(y = 20.5x+142\)

Step4: Find \(x\) for 2006

Since \(x\) represents the number of years since 1997, for 2006, \(x=2006 - 1997=9\)

Step5: Predict profit

Substitute \(x = 9\) into the regression equation \(y = 20.5x+142\)
\(y=20.5\times9+142=184.5+142=326.5\approx327\)

Answer:

Regression Equation: \(y = 20.5x+142\)
Final Answer: 327 thousand dollars