# TD_ANOVA Example | ANOVA | Teradata Vantage - Using TD_ANOVA to Determine Difference of Insect Sprays - 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

Your independent variable is insect spray type, and you have data on spray type A, B, C, D, E, and F. You can use one-way analysis to determine whether there is any difference among these spray types based on their means.

## TD_ANOVA Input: Insect_sprays

```groupA groupB groupC groupD groupE groupF
------ ------ ------ ------ ------ ------
7     17      1      5      6      9
10     17      2      5      1     13
10     11      0      3      3     11
12     14      1      3      6     16
13     13      4      4      4     13
14     11      2      6      5     22
14     16      3      4      3     15
14      7      1      2      6     24
17     19      3      5      3     26
20     21      0      5      2     26
20     21      7     12      3     15
23     17      1      5      1     10```

## TD_ANOVA SQL Call

```SELECT * from TD_ANOVA (
ON insect_sprays as InputTable
USING
ALPHA (0.05)
) AS dt;```

## TD_ANOVA Output Table

```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
------------------------------ ----------------------------- ------------------ ----------------- --------------------------- -------------------------- ----------- ------ ----------- -------- ----------
2656.902778000  1019.083333000  5  66  531.380556000  15.440657000  34.414376000  0.050000000  2.353809000  0.000000000  Reject Null hypothesis```