MATH225 WEEK 8 FINAL
4 Latest Versions
,
,
, An economist is trying to understand whether there is a strong link between CEO pay
ratio and corporate revenue. The economist gathered data including the CEO pay ratio
and corporate revenue for 30 companies for a particular year. The pay ratio data is
reported by the companies and represents the ratio of CEO compensation to the
median employee salary. The data are provided below. Use Excel to calculate the
correlation coefficient r between the two data sets. Round your answer to two decimal
places.
Perfect. Your hard work is paying off 😀
r= −0.17
The correlation coefficient, rounded to two decimal places, is r≈−0.17.
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.
Great work! That's correct.
r= 0.50
The correlation coefficient, rounded to two decimal places, is r≈0.50.
The table below gives the average weight (in kilograms) of certain people ages 1–20.
Use Excel to find the best fit linear regression equation, where age is the explanatory
variable. Round the slope and intercept to two decimal places.
Answer 2:
Well done! You got it right.
y = 2.89, x4.69
Thus, the equation of line of best fit with slope and intercept rounded to two
decimal places is yˆ=2.86x+4.69.
4 Latest Versions
,
,
, An economist is trying to understand whether there is a strong link between CEO pay
ratio and corporate revenue. The economist gathered data including the CEO pay ratio
and corporate revenue for 30 companies for a particular year. The pay ratio data is
reported by the companies and represents the ratio of CEO compensation to the
median employee salary. The data are provided below. Use Excel to calculate the
correlation coefficient r between the two data sets. Round your answer to two decimal
places.
Perfect. Your hard work is paying off 😀
r= −0.17
The correlation coefficient, rounded to two decimal places, is r≈−0.17.
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.
Great work! That's correct.
r= 0.50
The correlation coefficient, rounded to two decimal places, is r≈0.50.
The table below gives the average weight (in kilograms) of certain people ages 1–20.
Use Excel to find the best fit linear regression equation, where age is the explanatory
variable. Round the slope and intercept to two decimal places.
Answer 2:
Well done! You got it right.
y = 2.89, x4.69
Thus, the equation of line of best fit with slope and intercept rounded to two
decimal places is yˆ=2.86x+4.69.
