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 generatethe new model.
Highlighted the parts that I need most. Please be detailed withexplanation and use Excel. Thank you.
x | y |
5 | 6 |
6 | 9 |
7 | 11 |
8 | 13 |
9 | 14 |
10 | 15 |
11 | 15 |
12 | 13 |