In: Statistics and Probability
Consider the dataset between a quantitative input variable, ? and a quantitative response (output) variable, ? . Which of the following provides an optimal fit between them - a linear model, a complete quadratic model or a complete third order model?
(Hint: You can use adjusted multiple coefficient of determination, ?2 to determine the optimal?
model. Your answers below must be accompanied by appropriate computation in Excel)?2 value for the linear model = ________________
?2 value for the quadratic model = ________________ [10 points]?
?2 value for the third order model = ________________ [10 points]?
Therefore, the optimal model is (Circle one) Linear Quadratic Third-order
DATA
X (input) | Y (output) |
2 | 26.457 |
2.4 | 28.254 |
2.6 | 32.287 |
3.2 | 45.354 |
3.6 | 53.925 |
3.8 | 67.066 |
4.2 | 82.364 |
4.5 | 91.317 |
4.8 | 102.530 |
5.2 | 127.204 |
5.7 | 153.953 |
6.2 | 191.203 |
6.4 | 174.886 |
6.7 | 188.946 |
6.9 | 203.006 |