Z-test = X̅₁ -X̅₂ /σ*(√1/n₁ +1/n ₂)
Z-cal = X̅₁ -X̅₂ /σ*(√1/n₁ +1/n ₂)
Z-tab =NORMSINV(1-0.05/2)
P-value =2*(1-NORMSDIST(E21))
 |
two samples when population is normal and Ϭ is known and equal for two sided |
For One Sided
Upper Tail
Formulas
Z-test = X̅₁ -X̅₂ /σ*(√1/n₁ +1/n ₂)
Z-cal = X̅₁ -X̅₂ /σ*(√1/n₁ +1/n ₂)
Z-tab =NORMSINV(1-prob)
P-value =NORMSDIST(z-cal))
 |
Find two samples when population is normal and Ϭ is known and equal for one sided upper tail |
Lower Tail
Formulas
Z-test = X̅₁ -X̅₂ /σ*(√1/n₁ +1/n ₂)
Z-cal = X̅₁ -X̅₂ /σ*(√1/n₁ +1/n ₂)
Z-tab =NORMSINV(1-prob)
P-value =NORMSDIST(z-cal)) |
|
|