Anova test

Anova means Analysis of Variance. In this Excel tutorial you will teach yourself how to perform Anova.

Let's start from preparing data table. Here is an example:

Anova data table

Next go to the ribbon to the data tab. Click Data Analysis button.

Data Analysis ribbon button

If you don't have this button it means that you have to install Analysis ToolPak add-in.

New dialog box appears. Click Anova: Single Factor option.

Anova Single Factor

Select Input Range which is your data table (only numbers). In my sheet it is $B$2:$F$6

Anova Single Factor input

Anova test appears in the new worksheet.

Anova test ready

Anova test could be useful for statistics of some sets of data. Excel does it really good.