NOTE: For the following questions you can use excel analysis or a calculator, it is your choice.The scatter plot might give you most of the necessary information.

a.Using Excel construct a scatter plot.Discuss the output of the scatter plot.

b.Give (or calculate) the correlation coefficient.

c.Give (or calculate) the coefficient of determination.

d.Give (or calculate) the regression equation coefficients; Give the equation of regression.

e. (very important)

Based on the above values, in detail draw the conclusion:

Discuss the correlation coefficient r

Discuss the coefficientof determination r²

Discuss in detail the meaning of the regression equation