A high-school student has scored the following marks in a series of tests administered over 10 weeks in mathematics and 2 science subjects, Physics and Chemistry. The school management is interested to know if there is any correlation between his performance in Mathematics and the sciences.
Mathematics |
78 |
74 |
68 |
85 |
57 |
67 |
73 |
61 |
70 |
66 |
Physics |
73 |
69 |
60 |
81 |
62 |
63 |
75 |
64 |
63 |
59 |
Chemistry |
71 |
72 |
63 |
79 |
67 |
60 |
71 |
68 |
69 |
63 |
Required:
Calculate the multiple correlation between performance in mathematics and the sciences.
X | Y | Z |
78 | 73 | 71 |
74 | 69 | 72 |
68 | 60 | 63 |
85 | 81 | 79 |
57 | 62 | 67 |
67 | 63 | 60 |
73 | 75 | 71 |
61 | 64 | 68 |
70 | 63 | 69 |
66 | 59 | 63 |
r(X,Y) | 0.8255 | |
r(X,Z) | 0.7029 | |
r(y,Z) | 0.8683 | |
r(X,Y)SQR | 0.6815 | |
r(X,Z)SQR | 0.4941 | |
r(Y,Z)SQR | 0.7540 |
The above Calculations made through EXCEL
Get Answers For Free
Most questions answered within 1 hours.