Can you explain how to find p value in excel if null and alternative hypotheses are as follows: Ho : p1 < p2 Ho: p1>= p2 Kindly attach the link here if any
@professorjosh37432 жыл бұрын
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!
@milofungus29823 жыл бұрын
Thank you very much. The explanation is simple and easy to understand
Пікірлер
thank you sir
Thanks Josh! Great video (:
Can you explain how to find p value in excel if null and alternative hypotheses are as follows: Ho : p1 < p2 Ho: p1>= p2 Kindly attach the link here if any
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!
Thank you very much. The explanation is simple and easy to understand