TD_ZTest Input: example_table
col1 col2
---- ----
93 12
? 12
22 4
? 87
1 10
? 43
92 31
? 23
2 3
? 52
21 65
? 49
? 17
? 17
? 14
? 24
53 20
85 9
50 11
86 1
TD_ZTest SQL Call Using Column Names
SELECT * FROM TD_ZTest (
ON example_table AS InputTable
USING
FirstSampleColumn ('col1')
SecondSampleColumn ('col2')
FirstSampleVariance (0.5)
SecondSampleVariance (0.7)
AlternativeHypothesis ('two-tailed')
MeanUnderH0 (-20)
Alpha (0.05)
) AS dt;
TD_ZTest SQL Call Using Column Number Addresses
SELECT * FROM TD_ZTest (
ON example_table AS InputTable
USING
FirstSampleColumn ('[0]')
SecondSampleColumn ('[1]')
FirstSampleVariance (0.5)
SecondSampleVariance (0.7)
AlternativeHypothesis ('two-tailed')
MeanUnderH0 (-20)
Alpha (0.05)
) AS dt;
TD_ZTest Output
firstsamplecolumn secondsamplecolumn N1 N2 mean1 mean2 AlternativeHypothesis z_score Alpha CriticalValue p_value Conclusion
----------------- ------------------ -- -- ----- ----- --------------------- ------- ----- ------------- ------- ----------
col1 col2 10 20 50.5 25.2 TWO-TAILED 155.38 0.05 1.96 0.0 Reject Null hypothesis
.sidetitles view
firstsamplecolumn col1
secondsamplecolumn col2
N1 10
N2 20
mean1 5.05000000000000E 001
mean2 2.52000000000000E 001
AlternativeHypothesis TWO-TAILED
z_score 1.55377718139113E 002
Alpha 5.00000000000000E-002
CriticalValue 1.95996398454005E 000
p_value 0.00000000000000E 000
Conclusion Reject Null hypothesis