How to run an ANOVA test

AddMaple will automatically run an ANOVA test when you pivot by a categorical column and a numeric column.

In this example we are exploring a salary dataset and have pivoted by Salary and Education Level

AddMaple will display the summary of the ANOVA test in the legend on the right:

Click "See more" to go to the stats tab where you will see further details. AddMaple will give you an explanation of the test that has been performed and the results. In this example there is a strong relationship between Salary and Education Level.

You can view the numeric results below the text explanation.

For ANOVA we calculate:

• P-Value: the measure of probability as to whether the relationship between two columns is due to chance or not.
• F-Score: this compares the variation between group averages to the variation within the groups themselves. A higher F-Score means the differences are less likely to be due to chance.
• Eta-Squared: this indicates the strength of the relationship between categorical groups and numerical data. It shows what proportion of the total variance in the numerical data can be explained by the differences between the categorical groups.

We also perform Tukeys HSD on the categories. This determines which pair of categories have the most significant differences. In this example we can see that the most significant difference in salaries was between those with a Bachelor's degree vs those with a Master's.