Created Two Sided T-Test

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*
=(+E33*D9+E34*E9)/(E33+E34)













Pooled Standard Error
SE(ofP*)
=SQRT((E35*(1-E35)*(E33+E34))/(E33*E34))













Test Statistic
(P-T)/SE(of p*)
=(E29-E30)/E37














TABLE
0
NOT SIGNIFICANT





1
SIGNIFICANT





ANSWER
=IF(ABS(E39)>=E32,1,0)