A researcher is interested in whether the variation in the size of human beings is proportional throughout each part of the human. To partly answer this question they looked at the correlation between the foot length (in millimeters) and height (in centimeters) of 30 randomly selected adult males. The data is provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places. Foot length (mm) Height (cm)244.9     159.2248.5     164.8248.1     173.7252.3     171.7251.6     164.6256.5     171.4240.3     179.7252.7    183.1259.7    183.2263.3    177.9245.7    181.6261.0    172.9256.6    185.2256.0    169.6254.7    169.0248.1    177.6255.9    181.9259.4    180.4277.6    173.0287.7    175.0281.2    189.6269.0    174.1288.4    176.1281.8    189.7289.1    182.7283.2    186.0292.5    177.8285.4    187.7287.5    190.5276.8    194.1  Provide your answer below:R=___

Question
Asked Aug 30, 2019
45 views

A researcher is interested in whether the variation in the size of human beings is proportional throughout each part of the human. To partly answer this question they looked at the correlation between the foot length (in millimeters) and height (in centimeters) of 30 randomly selected adult males. The data is provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.

 
Foot length (mm) Height (cm)
244.9     159.2
248.5     164.8
248.1     173.7
252.3     171.7
251.6     164.6
256.5     171.4
240.3     179.7
252.7    183.1
259.7    183.2
263.3    177.9
245.7    181.6
261.0    172.9
256.6    185.2
256.0    169.6
254.7    169.0
248.1    177.6
255.9    181.9
259.4    180.4
277.6    173.0
287.7    175.0
281.2    189.6
269.0    174.1
288.4    176.1
281.8    189.7
289.1    182.7
283.2    186.0
292.5    177.8
285.4    187.7
287.5    190.5
276.8    194.1
 
 

Provide your answer below:

R=___

check_circle

Expert Answer

star
star
star
star
star
1 Rating
Step 1

Correlation: Correlation can be defined as the mutual association between two variables which lies between 0 and 1.

Step 2

The result obtained from EXCEL ...

E
F
Correlation Foot_length Height
Foot_length
Height
0.498725467
1
help_outline

Image Transcriptionclose

E F Correlation Foot_length Height Foot_length Height 0.498725467 1

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Math

Statistics

Data

Related Statistics Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: You are the foreman of the Bar-S cattle ranch in Colorado. A neighboring ranch has calves for sale, ...

A: Hello. Since you have posted multiple questions and not specified which question needs to be solved,...

question_answer

Q: A, B, C

A: In this question we have given a data of 10 sample observation based on that data we have to find co...

question_answer

Q: A researcher obtains hamstring measurements from a group of classmates. She then classifies those me...

A: Accordingt o the given question;A researcher obtains hamstring measurements from a group of classmat...

question_answer

Q: What is a standard abbreviation for the mean?

A: Mean is a measure of center in case of quantitative data.

question_answer

Q: I asked the attached question earlier today, and a response was sent, but none of the answer appeare...

A: Introduction to binomial distribution:Consider a random experiment involving n independent trials, s...

question_answer

Q: It is thought that prehistoric Indians did not take their best tools, pottery, and household items w...

A: Given data obtained for a collection of archeological sites in New Mexico as shown below. The least ...

question_answer

Q: I am working on constructing a histogram for some data for the 39 US national parks under 900,000 ac...

A: According to the given data41 ,66 ,233 ,775 ,169, 36 ,338 ,233 ,236, 64,183 ,61 ,13 ,308 ,77,520, 77...

question_answer

Q: BASED ON THIS DATA, what does the r^2 values tell you? and the linear regression line  is the inform...

A: Note:Hi there! Thank you for posting the question! However, the circumstances of the study presented...

question_answer

Q: Gentle Ben is a Morgan horse at a Colorado dude ranch. Over the past 8 weeks, a veterinarian took th...

A: Given data of glucose reading for 8 weeks92 87 82 107 99 109 85 89The sample x-bar is 93.8 . x is no...