Question

calculate the 95% confidence interval using the appropriate formula for this sample size. Remember to add and subtract the margin of error from the sample mean to calculate the lower and upper bounds of the confidence interval. Please provide excel formula

you plan to enrol n the new online 1Mean 6096 4996 Standard Deviatio 0 Lower Bound 1Upper Bound 10 Yes 11 Yes 12 13 Yes 14 15 16 Yes 17 18 es 19 21 Yes 23 Yes 24 Yes

Answer 1

95% margin of error :

$E=t_{\frac{\alpha}{2}, df} \times \frac{s}{\sqrt{n}}$

= $E= t_{0.025, 23} \times \frac{0.49}{\sqrt{24}} = 2.0686 \times 0.1 = 0.2069$

So, lower bound = $\bar{x} - E = 0.60 - 0.2069 = 0.3931$

upper bound = $\bar{x} + E = 0.60 + 0.2069 = 0.8069$