By using Microsoft Excel, the correlation coefficient r between the two data sets is -0.59.
In this exercise, we would plot the foot length (in millimeters) on the x-coordinates of a scatter plot while the height (in centimeters) would be plotted on the y-coordinate of the scatter plot through the use of Microsoft Excel.
On the Microsoft Excel worksheet, you should right click on any data point on the scatter plot, select format trend line, and then tick the box to display a linear equation for the line of best fit on the scatter plot.
Based on the scatter plot shown below, which models the relationship between the foot length (in millimeters) and the height (in centimeters), a linear equation for the line of best fit is as follows:
y = -0.5884x + 332.39
R-squared,
= 0.3474
Correlation coefficient, r = -0.5894 ≈ -0.59.
Complete Question;
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 length (cm)
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 length (cm)
240.2 199.9
241.3 198.9
242.5 197.9
243.8 196.9
244.9 195.9
255.3 194.9
256.9 194.9
257.1 193.9
258.4 192.9
259.6 191.9
260.1 189.9
216.7 188.9
262.3 187.9
264.4 186.9
265.3 185.9
266.5 184.9
226.7 183.9
257.8 182.9
268.9 181.9
269.1 161.9
270.9 162.9
236.7 163.9
271.8 164.9
273.9 165.9
274.7 166.9
275.3 167.9
246.7 168.9
279.6 169.9
280.1 141.9
281.9 142.9