TD_ANOVA 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_ANOVA SQL Call
SELECT * FROM TD_ANOVA(
ON insect2cols AS InputTable
USING
GroupValueColumn('groupValue')
GroupNameColumn('groupName')
NumGroups(6)
) AS dt;
TD_ANOVA Output
Sum of Squares (between groups) |
Sum of Squares (within groups) |
DF (between groups) |
DF (within groups) |
Mean Square (between groups) |
Mean Square (within groups) |
F_statistic |
Alpha |
Critical_f |
P_value |
Conclusion |
284.28333 |
5,149.9 |
5 |
54 |
56.856666 |
95.368515 |
0.5961785 |
0.05 |
2.38606986 |
0.702928314 |
Fail to Reject the Null Hypothesis |