1.Given below are seven observations collected in a regression study on two variables,x(independent variable) andy(dependent variable). Use Excel's Regression Tool to answer the following questions.

x

y

2

12

3

9

6

8

7

7

8

6

7

5

9

2

a.

What is the estimated regression equation?

b.

Perform at-test and determine whether or notxandyare related. Usea= 0.05.

c.

Perform anF-test and determine whether the model is significant. Usea= 0.05.

d.

Find and interpret the coefficient of determination.