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 is greater than Z, we then find the p-value that we want by subtracting the value we just calculated from 1.
ncG1vNJzZmirY2LCtHnWnqqtZWJjrq6t2ailmq%2BjY7CwuY6onKuemaGytHuiqKWcnaCpwGy1zWSKrZmknsC1tcKsZpqro560r7nEp6usZ4%2BqgqC5kJijm5xpZKy2gb6maJikkpmGoLHXnJylaF6dwa64