A sample proportion is stored in cell B2, the sample size is…
A sample proportion is stored in cell B2, the sample size is stored in cell B3, and the confidence level is 95%. Write an Excel formula to compute the margin of error for a population proportion confidence interval. Include all necessary Excel functions. Use cell references for inputs, as described above. Write as if you are using a single cell to compute the margin of error, including the formula/function for the critical value. Use B2 for p-hat, use 1-B2 for q-hat, and use B3 for the sample size.