Z Tests for Two Proportions in Excel

In this example we calculate a 2 Sample Z Test for the difference between proportions. Both the critical value and the p-value method are used.

Пікірлер: 4

  • @milofungus2982
    @milofungus29823 жыл бұрын

    Thank you very much. The explanation is simple and easy to understand

  • @niteenkumarpardeshi9098
    @niteenkumarpardeshi90982 жыл бұрын

    thank you sir

  • @apoorvaphadnis6628
    @apoorvaphadnis66282 жыл бұрын

    Can you explain how to find p value in excel if null and alternative hypotheses are as follows: Ho : p1 Ho: p1>= p2 Kindly attach the link here if any

  • @professorjosh3743

    @professorjosh3743

    2 жыл бұрын

    Hi Apoorva, thanks for watching. Sorry this response is late, I'm not that active here on KZread. If you have a single sided hypothesis test like you are mentioning, you would not multiply the final value by 2. Since your alternative hypothesis has a less than, your test stat (z-score) will be negative. If you use the norm.dist function, you will get the correct p-value directly as it finds the area to the left and that is what you want for a less than (left tailed) test. Hope that helps!