Excel Instructions: Hypothesis Testing for the Population Proportion p

To conduct the z-test for the population proportion (p) in Excel, we first need to calculate p-hat, and to do this, we remember that p-hat = x/n. Now we can calculate the test statistic using