Body Mass Index
Part 2 consists of working with Excel to test specific hypotheses concerning BMI values in order to answer the research questions below and prepare your report. Instructions for the meaning of these statistical tests, how to set them up, and how to use Excel are contained in the lecture videos in the Module 6 Lesson.
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 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?
3. Are there any differences in the percentage of males and the percentage of females in each of the four BMI categories? . 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?
