TD_ZTest Example | Z Test | Teradata Vantage - Using Two-tailed Test - Teradata Vantage

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