In: Statistics and Probability
Use the Spearman's rank correlation coefficient at the 0.05 CI to investigate the relation between two variables X and Y below.
|
X |
Y |
|
97 |
0 |
|
93 |
0 |
|
90 |
1 |
|
86 |
1 |
|
82 |
0 |
|
177 |
4 |
|
171 |
1 |
|
155 |
3 |
|
142 |
1 |
|
141 |
1 |
|
60 |
4 |
|
55 |
1 |
|
29 |
0 |
|
26 |
0 |
|
20 |
0 |
|
12 |
0 |
|
133 |
1 |
|
126 |
0 |
|
125 |
4 |
|
123 |
1 |
|
119 |
1 |
|
117 |
2 |
| X | Rank(X) | Y | Rank(Y) |
| 97 | 11 | 0 | 4.5 |
| 93 | 10 | 0 | 4.5 |
| 90 | 9 | 1 | 13 |
| 86 | 8 | 1 | 13 |
| 82 | 7 | 0 | 4.5 |
| 177 | 22 | 4 | 21 |
| 171 | 21 | 1 | 13 |
| 155 | 20 | 3 | 19 |
| 142 | 19 | 1 | 13 |
| 141 | 18 | 1 | 13 |
| 60 | 6 | 4 | 21 |
| 55 | 5 | 1 | 13 |
| 29 | 4 | 0 | 4.5 |
| 26 | 3 | 0 | 4.5 |
| 20 | 2 | 0 | 4.5 |
| 12 | 1 | 0 | 4.5 |
| 133 | 17 | 1 | 13 |
| 126 | 16 | 0 | 4.5 |
| 125 | 15 | 4 | 21 |
| 123 | 14 | 1 | 13 |
| 119 | 13 | 1 | 13 |
| 117 | 12 | 2 | 18 |
| Rank(X) | Rank(Y) | Rank(X)*Rank(Y) | Rank(X)2 | Rank(Y)2 | |
| 11 | 4.5 | 49.5 | 121 | 20.25 | |
| 10 | 4.5 | 45 | 100 | 20.25 | |
| 9 | 13 | 117 | 81 | 169 | |
| 8 | 13 | 104 | 64 | 169 | |
| 7 | 4.5 | 31.5 | 49 | 20.25 | |
| 22 | 21 | 462 | 484 | 441 | |
| 21 | 13 | 273 | 441 | 169 | |
| 20 | 19 | 380 | 400 | 361 | |
| 19 | 13 | 247 | 361 | 169 | |
| 18 | 13 | 234 | 324 | 169 | |
| 6 | 21 | 126 | 36 | 441 | |
| 5 | 13 | 65 | 25 | 169 | |
| 4 | 4.5 | 18 | 16 | 20.25 | |
| 3 | 4.5 | 13.5 | 9 | 20.25 | |
| 2 | 4.5 | 9 | 4 | 20.25 | |
| 1 | 4.5 | 4.5 | 1 | 20.25 | |
| 17 | 13 | 221 | 289 | 169 | |
| 16 | 4.5 | 72 | 256 | 20.25 | |
| 15 | 21 | 315 | 225 | 441 | |
| 14 | 13 | 182 | 196 | 169 | |
| 13 | 13 | 169 | 169 | 169 | |
| 12 | 18 | 216 | 144 | 324 | |
| Sum = | 253 | 253 | 3354 | 3795 | 3691 |


Conclusion: There is sufficient evidence to conclude that there is a significant linear relationship between x and y because the correlation coefficient is significantly different from zero.