The data are analyzed in a different context in an article by DiCiccio and Efron (1996). They are also described at (https://stat.ethz.ch/R-manual/R-devel/library/boot/html/cd4.html.) Read the “Description” section of that URL for further information. the excel document is attached below, please someone answer these three questions for me according to the data that is given. question1-3, EXCEL IS NEEDED. for 4-7, they’re individual questions. 1) The conditions are all met for the confidence interval to be valid (feel free to verify the normality condition on your own). Use Excel to determine the value of the statistic (in the same units in which each data value was originally recorded). Report your answer to three decimal places. (Note that the value of the statistic is not only the estimated value of the corresponding parameter, but it also forms the midpoint for the confidence interval.) 2) What is the correct multiplier to use for the 95% confidence interval? Report your answer to at least two decimal places. 3) What is the standard error of the statistic? Report to three decimal places. ——————————————————————————————————————————————————————————————————– 4) Suppose that in a random sample of 400 adults, 12 have a specific genetic mutation. What are the endpoints for a 95% confidence interval of the proportion of all adults that have the genetic mutation? 5) If a study finds that 26 of 200 men have sleep apnea and 13 of 200 women have sleep apnea, what would be the lower endpoint for a 90% confidence interval on the difference in the proportions of males (population 1) vs. females (population 2) that have sleep apnea? Assume all conditions for the interval to be valid are met, and report your answer to at least three decimal places. Hint: the upper endpoint is between 0.111 and 0.118–you can use this fact to help you identify if you correctly computed both endpoints. 6) If 37 of 52 patients given drug A recover, while 85 of 104 patients given drug B recover, then what is the standard error of the difference in sample proportions? Report your answer to at least 3 decimals. 7) If you were to construct a 99% confidence interval for a difference in proportions, what multiplier should you use? (Hint: first make sure you recognize whether it would be a t* or a z*). Report the answer to at least two decimal places.