How do you run an ANOVA test in Excel?

Question

3055 views around the world

You can reuse this answer
Creative Commons License

Answer 1 · 2018-01-28T00:25:25

The first step is to go to Data tab and click Data Analysis

enter image source here

If you cant find the Data Analysis button you must load the Analysis ToolPak add-in.

Next you select the ANOVA analysis you want to perform

enter image source here

You will be asked to provide a range of cells for example for a single factor ANOVA it would be something like that

enter image source here

Then click OK to get the results.