Purpose: Test for Significant Difference
Two tailed test: Indicates a difference on either direction
Enter Data
Test
Control
Test Results:
0.507
0.4728
Confidence Level:
0.8
Sample Size:
25000
25000
p-value=
=IF(2*(1-NORMSDIST(ABS(E39)))<0.0001,"<0.0001",2*(1-NORMSDIST(ABS(E39))))
Answer:
=VLOOKUP(E43,E41:F42,2)
Work Area
Test Proportion
P
=+D9
Control Proportion
T
=+E9
Absolute Difference
=ABS(+E30-E29)
Critical Point
a =
=ABS(NORMSINV((1-D10)/2))
Sample size control
N1
=+D11
Sample Size Test
N2
=+E11
Pooled Sample Proportion
p*
=(+E33D9+E34E9)/(E33+E34)
Pooled Standard Error
SE(ofP*)
=SQRT((E35*(1-E35)(E33+E34))/(E33E34))
Test Statistic
(P-T)/SE(of p*)
=(E29-E30)/E37
TABLE
0
NOT SIGNIFICANT
1
SIGNIFICANT
ANSWER
=IF(ABS(E39)>=E32,1,0)