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 SCATTERPLOTS OF THE DATA, ADD A TRENDLINE (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
MAKE A VISUAL 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]