Because some people are unable to stand to have their height measured, doctors use the height...

70.2K

Verified Solution

Question

Basic Math

Because some people are unable to stand to have their heightmeasured, doctors use the height from the floor to the knee toapproximate their patients’ height (in cm).

Height of KneeOverall Height
57192
47153
43146
44160
55171
54176

a. Use Excel to determine the correlation coefficient of thisdata

b. Use Excel to determine the regression equation of thisdata

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

Answer & Explanation Solved by verified expert
4.4 Ratings (664 Votes)
As we can see from the above output which we got in ExcelCorrelation is    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students