In: Statistics and Probability
A study of bone density on 5 random women at a hospital produced the following results.
| Age | 33 | 41 | 57 | 61 | 65 |
|---|---|---|---|---|---|
| Bone Density | 355 | 345 | 340 | 320 | 315 |
Step 2 of 3:
Estimate the correlation in words: positive, negative, no correlation.
Step 3 of 3:
Calculate the correlation coefficient, r. Round your answer to three decimal places.
Solution :
| X | Y | XY | X^2 | Y^2 |
| 33 | 355 | 11715 | 1089 | 126025 |
| 41 | 345 | 14145 | 1681 | 119025 |
| 57 | 340 | 19380 | 3249 | 115600 |
| 61 | 320 | 19520 | 3721 | 102400 |
| 65 | 315 | 20475 | 4225 | 99225 |
| n | 5 |
| sum(XY) | 85235.00 |
| sum(X) | 257.00 |
| sum(Y) | 1675.00 |
| sum(X^2) | 13965.00 |
| sum(Y^2) | 562275.00 |
| Numerator | -4300.00 |
| Denominator | 4659.61 |
| r | -0.9228 |
| r square | 0.8516 |
| Xbar(mean) | 51.4000 |
| Ybar(mean) | 335.0000 |
| SD(X) | 12.2898 |
| SD(Y) | 15.1658 |
| b | -1.1388 |
| a | 393.5328 |

Step 2 :
negative
Step 3 :
the correlation coefficient, r = -0.923