Iwant 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 . your job wl be to find the right numbers in the output to solve the problem excel descriptive statistics for cholesterol levels of males and females females males cholesterol 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 0.493 kurtosis 0.015 0.109 skewnes: s 0.086 range 47 61 minimum 176 166 maximum 223 227 32158 29647 sum count 164 148 confidence level (95.0%) 1.742 1.908 next we want to do a confidence interval for difference of the two means. the descriptive statistics are given above. put a 95% confidence interval around the difference of the female mean male mean. this will make clear the approach and meaning of a confidence interval of the difference of two means compared with the confidence interval for each mean. we can treat this as a large sample and use a z-value (if you use a t-value your answer will be the same within the specified rounding error) we will not assume equal variances. we want a 95% confidence interval for the difference of the two means, what is the boe for this confidence interval. use 3 significant decimal places and use the proper rules of rounding.

Consider the following explanation

Step-by-step explanation:

Part 1

Confidence interval for Population mean is given as below:

Confidence interval = Xbar ± Z*σ/sqrt(n)

We are given

Confidence level = 95%

Critical Z value = 1.96

(by using z-table)

Xbar = 200.318

σ = 10.721

n = 148

Lower limit = Xbar - Z*σ/sqrt(n)

Lower limit = 200.318 – 1.96*10.721/sqrt(148)

Lower limit = 200.318 – 1.7272

Lower limit = 198.591

Part 2

Confidence interval for Population mean is given as below:

Confidence interval = Xbar ± Z*σ/sqrt(n)

We are given

Confidence level = 95%

Critical Z value = 1.96

(by using z-table)

Xbar = 200.318

σ = 10.721

n = 148

Upper limit = Xbar + Z*σ/sqrt(n)

Upper limit = 200.318 + 1.96*10.721/sqrt(148)

Upper limit = 200.318 + 1.7272

Upper limit = 202.045

Part 3

Confidence interval for Population mean is given as below:

Confidence interval = Xbar ± Z*σ/sqrt(n)

We are given

Confidence level = 95%

Critical Z value = 1.96

(by using z-table)

Xbar = 196.085

σ = 12.372

n = 164

Lower limit = Xbar - Z*σ/sqrt(n)

Lower limit = 196.085 – 1.96*12.372/sqrt(164)

Lower limit = 196.085 – 1.8935

Lower limit = 194.191

Part 4

Confidence interval for Population mean is given as below:

Confidence interval = Xbar ± Z*σ/sqrt(n)

We are given

Confidence level = 95%

Critical Z value = 1.96

(by using z-table)

Xbar = 196.085

σ = 12.372

n = 164

Upper limit = Xbar + Z*σ/sqrt(n)

Upper limit = 196.085 + 1.96*12.372/sqrt(164)

Upper limit = 196.085 + 1.8935

Upper limit = 197.979

Part 5

Confidence interval for difference is given as below:

Confidence interval = (X1bar – X2bar) ± Z* sqrt[(σ12 / n1)+(σ22 / n2)]

We are given

Confidence level = 95%

Critical Z value = 1.96

(by using z-table)

Confidence interval = (X1bar – X2bar) ± Z* sqrt[(σ12 / n1)+(σ22 / n2)]

Confidence interval = (200.318 – 196.085) ± 1.96* sqrt[(10.721^2 / 148)+( 12.372^2 / 164)]

Confidence interval = 4.233 ± 1.96* 1.3077

Confidence interval = 4.233 ± 2.563092

Lower limit = 4.233 - 2.563092 = 1.669908

Upper limit = 4.233 + 2.563092 = 6.796092

Confidence interval = (1.670, 6.796)

b

step-by-step explanation: