# 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. Step 1: On the top right corner of the data tab click data analysis. Step 2:  Select Anova: Single Factor and click OK. Step 3: Click in the Input Range box and select the range A2:C10 and output range as shown below and click ok The result will be 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.