Question

Consider the data in the worksheet below.

X	Y
5	6
6	9
7	11
8	13
9	14
10	15
11	15
12	13

a. Generate a model for y as a function of x.

b. Is this model useful? Justify your conclusion based on:

i. R2 Adjusted

ii. Hypothesis test for model coefficient

iii. overall model adequacy test

iv. regression assumptions.

c. If needed, modify model as appropriate and generate a new model.

Please be as detailed in the answer as well as your explanation. Thank you.

Answer 1

Model-> y=2.691+1.095x

b) i)R2 adj=0.673

ii)Hypothesis test for model coeff give pvalue as 0.00775. coeff is significant at 1% level