Single factor ANOVA in Excel or one way ANOVA in Excel Explained

In this Example we will learn how to perform a single factor or One way ANOVA in Excel. A single factor or one way ANOVA is used to test the null hypothesis, i.e. the mean from all the population are all equal. And alternate hypothesis is at least one among the mean is different.

                                              H0: μ1 = μ2 = μ3

                                             H1: at least one mean is different.

Let’s take an example of marks scored in three subjects, to demonstrate One way ANOVA in Excel.

one way ANOVA in Excel 1

 

Step 1: On the top right corner of the data tab click data analysis.

one way ANOVA in Excel 2

Note: if you can’t able to find the Data Analysis button? Click here to load the Analysis ToolPak add-in.

 

Step 2:  Select Anova: Single Factor and click OK.

one way ANOVA in Excel 3

 

Step 3: Click in the Input Range box and select the range A2:C10 and output range as shown below and click ok

one way ANOVA in Excel 4

The result will be

one way ANOVA in Excel 5

If F > F crit, we reject the null hypothesis. In this case F crit value is 3.402826 and F value is 0.071109. So we cannot reject null hypothesis. So mean of the all the three subjects are same.

If you want to test the mean of two subjects you can use T-Test.

previous one way ANOVA in Excel                                                                                                                 next one way ANOVA in Excel 4