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:

Next go to the ribbon to the data tab. Click **Data Analysis** 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.

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

Anova test appears in the new worksheet.

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