In: Statistics and Probability
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 and
iv) regression assumptions
c. If needed, modify model as appropriate and generate the new model.
Highlighted the parts that I need most. Please be detailed with explanation and use Excel. Thank you.
x | y |
5 | 6 |
6 | 9 |
7 | 11 |
8 | 13 |
9 | 14 |
10 | 15 |
11 | 15 |
12 | 13 |