Make sure that Labels in the first-row Checkbox is selected, and then click on OK.We have selected the output range cell as G1, where the output is going to be displayed.Click on the output range box and select the output cell in the worksheet, which is shown below.Next step, we want to select the output range where our output needs to be displayed.Now the input range has been selected, make sure that Column Checkbox is selected.As we can see in the above screenshot, we have selected ranges along with the student name to get the exact output.Click on the input range box to select the range $B$1:$D$7 as shown below.Now we can see the input range in the dialogue box.So that we will get the ANOVA: Single-factor dialogue box as shown in the below screenshot.Click on the ANOVA: Single-factor tool and then click OK.
In the below screenshot, we can see the list of analysis tool where we can see the ANOVA- Single-factor tool.First, Go to the DATA menu and then click on the DATA ANALYSIS.Now we are going to check that student’s marks are significantly different by using the ANOVA tool by following the below steps.
In this example, we are going to see how to apply Excel ANOVA single factor by following the below example.Ĭonsider the below example, which shows students marks scored on each subject.
You can download this ANOVA Excel Template here – ANOVA Excel Template Excel ANOVA – Example #1 Let’s see the working of the excel ANOVA single factor built-in tool with some different Examples.