TD_ANOVA Output - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

Output Table Schema

Column Data Type Description
sum_of_squares (between groups) DOUBLE The sum of squares (variation) between groups.
sum_of_squares (within groups) DOUBLE The sum of squares (variation) within groups.
Df (between groups) INTEGER The degrees of freedom corresponding to the between groups sum of squares.
Df (within groups) INTEGER The degrees of freedom corresponding to the within group sum of squares.
mean_square (between groups) DOUBLE The mean of sum of squares, which is calculated by dividing the sum of squares (between groups) by the degrees of freedom (between groups).
mean_square (within groups) DOUBLE The mean of sum of squares, which is calculated by dividing the sum of squares (within groups) by the degrees of freedom (within groups).
F_statistic DOUBLE

The F-statistic is calculated as the ratio of between group sum of squares/(k-1) and within group sum of squares/(N-k+1).

The null hypothesis is rejected when F-statistic is greater than the critical value of F.

alpha DOUBLE The level of significance of the test.
critical_f DOUBLE The critical value of F denoted by (k-1, N-k) where:
  • k is the number of groups
  • N is the total number of observations
  • k-1 is the degrees of freedom between groups
  • N-k+1 is the degrees of freedom within groups
p_value DOUBLE

The probability value associated with the F-statistic value.

The null hypothesis is rejected when p_value is less than alpha.

conclusion VARCHAR The result of the test based on if the null hypothesis is rejected or not.