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: