Given the following set of data what is the correlation value between these two variables? X: 0 1 2 3 4 5 6 7 8 9 10 Y: 563 552 541 530 519 508 497 486 475 464 453
Solution :
X | Y | XY | X^2 | Y^2 |
0 | 563 | 0 | 0 | 316969 |
1 | 552 | 552 | 1 | 304704 |
2 | 541 | 1082 | 4 | 292681 |
3 | 530 | 1590 | 9 | 280900 |
4 | 519 | 2076 | 16 | 269361 |
5 | 508 | 2540 | 25 | 258064 |
6 | 497 | 2982 | 36 | 247009 |
7 | 486 | 3402 | 49 | 236196 |
8 | 475 | 3800 | 64 | 225625 |
9 | 464 | 4176 | 81 | 215296 |
10 | 453 | 4530 | 100 | 205209 |
n | 11 |
sum(XY) | 26730.00 |
sum(X) | 55.00 |
sum(Y) | 5588.00 |
sum(X^2) | 385.00 |
sum(Y^2) | 2852014.00 |
Numerator | -13310.00 |
Denominator | 13310.00 |
r | -1.0000 |
r square | 1.0000 |
Xbar(mean) | 5.0000 |
Ybar(mean) | 508.0000 |
SD(X) | 1.7078 |
SD(Y) | 18.7861 |
b | -11.0000 |
a | 563.0000 |
correlation = -1.00
Get Answers For Free
Most questions answered within 1 hours.