Question: Use Excel for these questions-

Here is a Table (attached) showing the lean body mass (in kg) and resting metabolic rate (in calories burned per 24 hours) for 12 women and 7 men. Researchers believe that lean body mass is an important influence on metabolic rate.

(a) (4pts) Make a scatterplot of the data (metabolism rate vs lean body mass), using different symbols or colors for men and women.

(b) (3pts) Use Excel to find the correlation coefficient, r, between lean body mass and metabolism rate for the whole group (males and females together).

(c) (3pts) Use Excel to find the correlation coefficients separately in each sex. Which one is stronger?