In: Statistics and Probability
A study was conducted to determine whether the final grade of a student in an introductory psychology course is linearly related to his or her performance on the verbal ability test administered before college entrance. The verbal scores and final grades for all 10 students in the class are shown in the table below.
Student | Verbal Score ?x | Final Grade ?y |
11 | 3636 | 9090 |
22 | 7474 | 8484 |
33 | 4848 | 8686 |
44 | 7474 | 6868 |
55 | 8080 | 7676 |
66 | 2828 | 9191 |
77 | 7272 | 9797 |
88 | 6767 | 9494 |
99 | 3131 | 7777 |
1010 | 2727 | 9797 |
Find the following:
(a) The correlation coefficient: r=
(b) The least squares line: ?̂ =
(c) Calculate the residual for the fifth student:
Run Regression analysis in excel
- Bring data in to excel sheet
(a) The correlation coefficient: r= -0.34 (negative and weak correlation between the variables)
(b) The least squares line: ?̂ = -0.153x + 94.190 (highlighted in the summary output)
(c) Calculate the residual for the fifth student: -5.989 is the residual for the fifthe student ( highlighted in the summary output)