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

• Once we have calculated our test statistic (z), we find the probability that p is less than or equal to the test statistic (Z) using the Excel formula=NORMSDIST(z).
• Since our alternative hypothesis is that p isgreater thanZ, we then find the p-value that we want by subtracting the value we just calculated from 1.