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 kneeoverall height57192471534314644160551715417 6

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

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