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 tableNext go to the ribbon to the Data tab. Click Data Analysis button.Data Analysis ribbon buttonIf 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 FactorSelect Input Range which is your data table (only numbers). In my sheet it is $B$2:$F$6Anova Single Factor inputAnova 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 well.

Further reading: 
Anova two factor with replication
Anova two factor without replication
How to create KPI dashboard?
Interactive Charts
Power Query
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell