Compute in excel
Text Question 8.3.8 (Confidence Interval for a Mean, not aproportion) (adapted) The Table below contains the percentage ofwomen receiving prenatal care in 2009 for a sample of countries.(i) Find the 90% confidence interval for the average percentage ofwoman receiving prenatal care in 2009 using the normaldistribution. (Express as percentages with two digits, as shown inthe data.) (ii) Find the 90% confidence interval for the averagepercentage of woman receiving prenatal care in 2009 using thet-distribution. (Express as percentages with two digits, as shownin the data.) (iii) Are you answers similar? Why or why not? Note:You’ll find the data below reproduced in the Excel answer template.70.08 72.73 74.52 75.79 76.28 76.28 76.65 80.34 80.60 81.90 86.3087.70 87.76 88.40 90.70 91.50 91.80 92.10 92.20 92.41 92.47 93.0093.20 93.40 93.63 93.68 93.80 94.30 94.51 95.00 95.80 95.80 96.2396.24 97.30 97.90 97.95 98.20 99.00 99.00 99.10 99.10 100.0 100.0100.00 100.00 100.00 (b) Text Question 8.2.5 (Confidence Intervalfor a Proportion) In 2013, the Gallup poll asked 1039 U.S. adultsif they agreed that a conspiracy was behind the assassination ofPresident Kennedy. And found that 634 did so. Using a 98%confidence interval, estimate the proportion of Americans whobelieve in this conspiracy. Express both lower and upper bounds asa percentage, rounding to 2 digits, e.g., 57.29, 65.34.
