Question

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 47.3 cm

d. Find the overall height from a knee height of 55.2 cm

Choose one • 20 points

• a. r = 0.83833586

  b. Equation: y = 2.5163x + 39.226

  c. 158.24699

  d. 178.12576

• a. r = 0.91541578

  b. Equation: y = 2.5163x + 39.226

  c. 158.24699

  d. 178.12576

• a. r = 0.91541578

  b. Equation: y = 2.5163x + 39.226

  c. 157.4921

  d. 177.6225

• a. r = 0.0.83833586

  b. Equation: y = 2.5163x + 39.226

  c. 157.4921

  d. 177.6225

Answer 1

Answer:

Height of Overall Knee Height 57.7 1923 47.5 43.5 146.2 44.8 iss 1714 54.9 176.7 SUMMARY OUTPUT Regression Statistics Multiple R 0915416 R Square 0.837986 Square Standard 7575708 Observations 6

ANOVA df Significance MS Regression 1 1187.383 1187.382938 20.68923 0.010429 Residual4 229.5654 57.39134887 Total 1416.948 Coefficients Standard t Stat P-value | Lower 95% Error 39.2259728.19903 1391039556 0.236594 -39.0671 Height of 2516264 0.553202 4.548541756 0.010429 0.980328 Knee Above is the result from MsExcel. a. The correlation coefficient is 0.9154 b. The regression equation is y 39.226+ 2.516x

As per HomeworkLib policy,I have answered 1st 2 parts