Because some peopleare unable to stand to have their height measured, doctors use theheight 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 todetermine the correlation coefficient of this data
b. Use Excel todetermine the regression equation of this data
c. Find the overallheight from a knee height of 45.3 cm
d. Find the overallheight from a knee height of 52.7 cm
