TD_FTest Input: insect2cols
groupName groupValue
--------- ----------
groupE 34
groupF 15
groupE 31
groupF 26
groupE 21
groupF 26
groupE 11
groupF 10
... ...
groupD 12
groupB 21
groupD 12
groupB 19
groupD 5
groupB 21
... ...
groupC 13
groupC 11
groupC 10
groupC 21
groupC 11
groupA 20
groupA 17
groupA 20
groupA 23
groupA 14
... ...
TD_FTest SQL Call
SELECT * FROM TD_FTest(
ON insect2cols AS InputTable
USING
SampleNameColumn('groupName')
SampleValueColumn('groupValue')
FirstSampleName('groupE')
SecondSampleVariance(100.0)
df2(25)
) AS dt;
TD_FTest Output
firstsamplevariance secondsamplevariance varianceratio df1 df2 CriticalValue Alpha p_value Conclusion
------------------- -------------------- ------------- --- --- ------------- ----- ------- ----------
305.2888888889 100 3.0528888889 9 25 2.6766418069 0.05 0.0263040598 Reject Null hypothesis