a) Fill in the second row of the following table using the regression equation:

y= 2.9197x +2.264

r²= 0.438

b)Fill in the third row by computing average y values using only data points whosexvalue is near the number in row 1. For example, forx= 1 you might estimate the regression valuey? from the data using the average of allyvalues for which the correspondingxis between 0.5 and 1.5. (Note: You may want to copy the data set onto a blank worksheet before manipulating it.)

X 2 3 4 5 6 7 8 9 empirical estimate for j