Part 2 (150 points) 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.
ASSIGNMENT.
BODY MASS INDEX RESEARCH QUESTIONS
1. Is there any difference between the mean BMI of males and females?
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?
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?
