In: Statistics and Probability
final exam scores and the students’ confidence rating on mathematical skills.
Student ID |
Exam score |
Math confidence |
Z exam |
Z math conf |
|
A |
60 |
1 |
A |
-.77 |
-1.61 |
B |
80 |
5 |
B |
.77 |
1.36 |
C |
70 |
3 |
C |
0 |
-0.12 |
D |
50 |
2 |
D |
-1.55 |
-0.87 |
E |
90 |
4 |
E |
1.55 |
0.62 |
F |
70 |
4 |
F |
0 |
0.62 |
Mean |
70 |
3.17 |
|||
SD |
12.9 |
1.34 |
|
|
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.7686 | |||||
R Square | 0.5908 | |||||
Adjusted R Square | 0.4885 | |||||
Standard Error | 10.1147 | |||||
Observations | 6 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 1 | 590.7692308 | 590.7692 | 5.774436 | 0.074114 | |
Residual | 4 | 409.2307692 | 102.3077 | |||
Total | 5 | 1000 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 46.6154 | 10.5713 | 4.409635 | 0.011604 | 17.26487 | 75.9659 |
X | 7.3846 | 3.0731 | 2.403006 | 0.074114 | -1.14761 | 15.91684 |
Excel Command = Data > Data analysis > regression > select the data > ok
____________________________________________________
a) Correlation = (0.5908)0.5 = 0.7686
_____________________________________________________
Y = Exam score , X= confidence
______________________________________________________
c) Standard error = 10.1147
___________________________________________________________
d) It tell How wrong is the predicted value on an average by varying a unit in 'x'