Refer to the Data Set 1 in Appendix B BELOW and use the sample data with Excel a
ID: 3133507 • Letter: R
Question
Refer to the Data Set 1 in Appendix B BELOW and use the sample data with Excel and/or SAS to accomplish the following: 1) Construct a 99% confidence interval estimate of the mean body mass index for men. 2) Construct a 99% confidence interval estimate of the mean body mass index for women. 3) Compare and interpret the results. It is known that men have a mean weight that is greater than the mean weight for women, and the mean height of men is greater than the mean height of women, but do men also have a mean body mass index that is greater > than the mean body mass index of women? BMI MEN BMI WOMEN 23.8 19.6 23.2 23.8 24.6 19.6 26.2 29.1 23.5 25.2 24.5 21.4 21.5 22 31.4 27.5 26.4 33.5 22.7 20.6 27.8 29.9 28.1 17.7 25.2 24 23.3 28.9 31.9 37.7 33.1 18.3 33.2 19.8 26.7 29.8 26.6 29.7 19.9 31.7 27.1 23.8 23.4 44.9 27 19.2 21.6 28.7 30.9 28.5 28.3 19.3 25.5 31 24.6 25.1 23.8 22.8 27.4 30.9 28.7 26.5 26.2 21.2 26.4 40.6 32.1 21.9 19.6 26 20.7 23.5 26.3 22.8 26.9 20.7 25.6 20.5 24.2 21.9 First 40 are male BMI last 40 are female BMI
Explanation / Answer
I have used the data analysis in MS-EXCEL to find the Confidence Interval. If you currently don't have this plugin in excel please follow the following steps to get it.
Go to File-> Options -> Add-Ins.
There select the Analysis toolpak and click on go.
In the new window which should just appear now select the checkbox Anaysis Toolpak and then select OK.
Now the Data Analysis add-in should appear in the Data Scetion.
Using this we get the following results.
based on these data we can not say that mean body mass index of men is greater than that of women since to conclude this the confidence interval of two shouldn't overlap.
Men Women Sample Mean 25.8 25.9 Confidence Level(99.0%) 2.0 2.2 Lower Limit 23.8 23.7 Upper Limit 27.9 28.1