In: Math
Because some people are unable to stand to have their height measured, doctors use the height from the floor to the knee to approximate their patients’ height (in cm).
| Height of Knee | Overall Height |
| 57.7 | 192.3 |
| 47.5 | 153.3 |
| 43.5 | 146.2 |
| 44.8 | 160.4 |
| 55.6 | 171.4 |
| 54.9 | 176.7 |
a. Use Excel to determine the correlation coefficient of this data
b. Use Excel to determine the regression equation of this data
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
Please don't hesitate to give a "thumbs up" for the
answer in case the answer has helped you
On excel we have performed the regression analysis. Answers are in the image below:
