Example: Using Two Samples - Analytics Database

TD_ZTest Input: boston2cols

The following example assumes the boston2cols input table exists:

groupName     groupValue
---------     ----------
RM            -0.2276075065
RM            -0.4401326616
RM            -1.1572243415
RM             2.4224510607
RM             0.1294925842
...            ...
NOX           -0.1467014464
NOX           -0.1467014464
NOX            1.1684487614
NOX            0.421782837
NOX            1.1684487614
...            ...

TD_ZTest SQL Call

SELECT * FROM TD_ZTest(
  ON boston2cols AS InputTable
  USING
    FirstSampleName('NOX')
    SecondSampleName('RM')
    SampleNameColumn('groupName')
    SampleValueColumn('groupValue')
) AS dt;

TD_ZTest Output

firstsamplecolumn secondsamplecolumn N1  N2  mean1         mean2        AlternativeHypothesis z_score        Alpha CriticalValue p_value      Conclusion
----------------- ------------------ --  --  -----         -----        --------------------- -------        ----- ------------- ------- ----------
NOX               RM                 360 360 -0.0008249076 0.0008249076 TWO-TAILED            -0.0474590359  0.05  1.9599639845  0.9621473781 Fail to reject Null hypothesis