Question

The sample data below have been collected based on a simple random sample from a normally distributed population.
Complete parts a and b.
3 7 0 0 0 1 9 3 9 1
a. Compute a 98% confidence interval estimate for the population mean.
The 98% confidence interval for the population mean is from_________ to ___________.
(Round to two decimal places as needed. Use ascending order.)
b. Show what the impact would be if the confidence level is increased to 99 %. Discuss why this occurs. Select the correct
choice below and fill in the answer boxes to complete your choice.
(Round to two decimal places as needed. Use ascending order.)
A. The 99% confidence interval is from_____ to ______, which is narrower than
the interval in part a. This is because the margin of error is greater for a higher confidence level.
B. The 99 % confidence interval is from__________ to_____________ , which is narrower than
the interval in part a. This is because the margin of error is greater for a smaller confidence level.

C. The 99 % confidence interval is from __________ to ________________ , which is wider than the
interval in part a. This is because the margin of error is greater for a higher confidence level.
D. The 99 % confidence interval is from____________ to ________________, which is wider than the
interval in part a. This is because the margin of error is greater for a smaller confidence level

Kindly answer in excel sheet

Answer 1