# 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
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

R=___

check_circle

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 ...

### Want to see the full answer?

See Solution

#### 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