MODULE 6 ASSIGNMENT.
BODY MASS INDEX RESEARCH QUESTIONS
1. Is there any difference between the mean BMI of males and females? [DO A T-TEST ON THE DATA SORTED BY GENDER]
2. Is there any correlation (positive or negative) between BMI and age?
(a) For males, is there any correlation between BMI and age?
(b) For females, is there any correlation between BMI and age?
[MAKE TWO SCATTER PLOTS OF THE DATA, ADD A TREND LINE (with “display equation on chart” and“display R-squared value on chart”) AND DO TWO CORRELATION TESTS ON THE DATA SORTED BY GENDER]
3. Are there any differences in the percentage of males and the percentage of females in each of the four BMI categories? [MAKE A BAR GRAPH OF THE NUMBER OF MALES AND FEMALES IN EACH CATEGORY AND COMPARISON].
Compare your answer to the conclusion for Question 1 and comment if they match or if they contradict each other.
4. Is there any correlation between height and weight?
(a) For males, is there a correlation between height and weight?
(b) For females, is there a correlation between height and weight?
[MAKE TWO SCATTERPLOTS OF THE DATA, ADD A TRENDLINE (with “display equation on chart” and“display R-squared value on chart”) AND DO TWO CORRELATION TESTS]
