Because some people are unable to stand to have their heightmeasured, doctors use the height from the floor to the knee toapproximate their patients’ height (in cm).
| Height of Knee | Overall Height |
| 57 | 192 |
| 47 | 153 |
| 43 | 146 |
| 44 | 160 |
| 55 | 171 |
| 54 | 176 |
a. Use Excel to determine the correlation coefficient of thisdata
b. Use Excel to determine the regression equation of thisdata
c. Find the overall height from a knee height of 45.3 cm
d. Find the overall height from a knee height of 52.7 cm
Choose one • 20 points
a. r = 0.73220213
b. Equation: y = 2.0217x + 67.746
c. 159.32901
d. 174.28959
a. r = 0.82544241
b. Equation: y = 2.5109x + 40.79
c. 154.53377
d. 173.11443
a. r = 0.53611996
b. Equation: y = 2.0217x + 67.746
c. 159.32901
d. 174.28959
a. r = 0.908553861
b. Equation: y = 2.5109x + 40.79
c. 154.53377
d. 173.11443
