the radio on their commute to work. a. In E14 find the sample proportion (p-hat) by entering the formula =average(C2:C101) b. In E15 find q-hat by entering the formula =1-E14 C. In E16 find z for a 95% confidence interval by entering the formula =norm inv(.025,0,1) d. In E17 find the stdev of the proportion by entering the formula =sqrt((E14*E15)/100) e . In E18 find the margin of error by entering the formula =ABS(E16*E17) f. In E19 find the lower limit by entering the formula =E14-E18 g. In E20 find the upper limit by entering the formula =E14+E18 h. In E21 find the width of the interval by entering the formula =E20-E19 i. Copy/Paste cells D14-D21 and E14-E21 here: p-hat 0.7 q-hat 0.3 2 -1.959963985 Std Dev 0.045825757 Margin Of Error 0.089816833 Lower Confidence Limit 0.610183167 Upper Confidence Limit 0.789816833 Width of Interval 0.179633666 8. Confidence Interval: 9. Interpret the confidence interval in context. 10. Explain why the alpha level is .025 (see 7c) when the confidence level is 95%. X English (United States) Focus E