In: Statistics and Probability
I want you to conduct a hypothesis test for a difference of means for cholesterol levels between male and female students. There are 148 females and 164 males in our sample. You can treat this as a large sample problem and use z-values for confidence intervals and hypothesis tests (however, Excel uses a t-value in anything it calculates). The output from Microsoft Excel is given below to help. Your job will be to find the right numbers in the output to help solve the problem.
EXCEL DESCRIPTIVE STATISTICS FOR CHOLESTEROL LEVELS OF MALES AND FEMALES
Cholesterol | Females | Males |
Mean | 200.318 | 196.085 |
Standard Error | 0.881 | 0.966 |
Median | 201 | 196 |
Mode | 194 | 196 |
Standard Deviation | 10.721 | 12.372 |
Sample Variance | 114.939 | 153.072 |
Kurtosis | -0.493 | 0.015 |
Skewness | -0.109 | 0.086 |
Range | 47 | 61 |
Minimum | 176 | 166 |
Maximum | 223 | 227 |
Sum | 29647 | 32158 |
Count | 148 | 164 |
Confidence Level (95.0%) | 1.742 | 1.908 |
2. The Descriptive Statistics are given above. Put a 95% Confidence Interval around just the female mean. What is the lower bound for the 95% CI? Use 3 significant decimal places and use the proper rules of rounding.
1. We conduct a hypothesis test for a difference of means for cholesterol levels between male and female students. There are nF = 148 females and nM =164 males in our sample.
The null and alternative hypothesis is
Test statistic is
where
Test statistic value is
with degree of freedom is
p-value is 0.0013 with 310 degree of freedom for two tailed hypothesis
The p-value is less than level of significance (0.05). We reject the null hypothesis and conclude that there is a difference of means for cholesterol levels between male and female students.
2. 95% Confidence Interval around just the female mean
the lower bound for the 95% CI is 198.591