Question

In: Math

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

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 192
47 153
43 146
44 160
55 171
54 176

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

Solutions

Expert Solution

As we can see from the above output which we got in Excel

Correlation is 0.908

And by fitting regression line we can see that the equation is

Y = 2.5109X + 40.9898

where Y = Overall Height

X = Height of knee

and we can also find the overall height from the above equation  

by putting x=45.3 in the above eqn we get y=154.5337

and similarly by putting x = 52.7 we get y = 173.11443

So the last set of answers is right


Related Solutions

Because some people are unable to stand to have their height measured, doctors use the height...
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...
Because elderly people may have difficulty standing to have their height measured, a study looked at...
Because elderly people may have difficulty standing to have their height measured, a study looked at the relationship between overall height and height to the knee. Here are data (in centimeters) for five elderly men: Knee Height ? 56.5 46.3 41.2 47.7 52.7 Height ? 192.4 151.8 149.7 162.1 174.5 What is the equation of the least-squares regression line for predicting height from knee height? ANSWER: ?̂ =
Because elderly people may have difficulty standing to have their height measured, a study looked at...
Because elderly people may have difficulty standing to have their height measured, a study looked at the relationship between overall height and height to the knee. Here are data (in centimeters) for five elderly men: Knee Height x 57.2 45.7 42.9 45.6 52.4 Height y 191.6 153.7 145.2 163.6 174.3 What is the equation of the least-squares regression line for predicting height from knee height? ANSWER: ŷ =
Some people believe that the use of staffing technology and software is wrong because it dehumanizes...
Some people believe that the use of staffing technology and software is wrong because it dehumanizes the staffing experience, making it nothing but a mechanical process that treats applicants like digital widgets. Others believe staffing technology helps organizations identify the most qualified applicants while weeding out those who are not qualified at all, making the hiring process smooth and freeing up the HR department for other tasks. Where do you stand on this topic? Defend your position.
A family is in therapy because they have been unable to resolve conflicts and are arguing...
A family is in therapy because they have been unable to resolve conflicts and are arguing frequently. When using a strategic family therapy approach, which of the following directives might the PMHNP suggest to create a sense of togetherness? A. Encourage the family to address concerns by writing letters to each other B. Direct the family to temporarily become overly dependent on one another C. Ask the family to engage in pleasant activities following the problem behavior D. Exaggerate in...
This theory suggest that certain countries are unable to "modernize" because they do not have an...
This theory suggest that certain countries are unable to "modernize" because they do not have an econmic culture to produce economic growth?
1.A family is in therapy because they have been unable to resolve conflicts and are arguing...
1.A family is in therapy because they have been unable to resolve conflicts and are arguing frequently. When using a strategic family therapy approach, which of the following directives might the PMHNP suggest to create a sense of togetherness? A. Encourage the family to address concerns by writing letters to each other B. Direct the family to temporarily become overly dependent on one another C. Ask the family to engage in pleasant activities following the problem behavior D. Exaggerate in...
we were unable to have class because of the scheduling problems with airlines/flights as a result...
we were unable to have class because of the scheduling problems with airlines/flights as a result of the storms that rolled through . Think about business concepts like capacity, supply/demand, etc. Please respond to the following question(s): 1) Given the vast and intricate network of numerous airlines, who are all competing for market share, why is it important to plan for emergencies/storms/"acts of God" when it comes to meeting passenger demands? 2) Pick ONE airline and provide its mission/vision and...
Does knee height predict overall height? Since elderly people may have difficulty standing to have their...
Does knee height predict overall height? Since elderly people may have difficulty standing to have their heights measured, a study looked at predicting overall height (y) in centimeters, from height to the knee (x) in centimeters. Use this data to answer the following questions. Data looking at knee height (in cm) and overall height (in cm) Knee Height (cm) 57.70 47.40 43.50 44.80 55.20 54.60 Overall Height (cm) 192.10 153.30 146.40 162.70 169.10 177.80 What is the mean x and...
Does knee height predict overall height? Since elderly people may have difficulty standing to have their...
Does knee height predict overall height? Since elderly people may have difficulty standing to have their heights measured, a study looked at predicting overall height (y) in centimeters, from height to the knee (x) in centimeters. Use this data to answer the following questions. Data looking at knee height (in cm) and overall height (in cm) Knee Height (cm) 57.70 47.40 43.50 44.80 55.20 54.60 Overall Height (cm) 192.10 153.30 146.40 162.70 169.10 177.80 What is the mean x and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT