Step 4: For the Input Range, choose the values from E1:E11.Step 3: The “ ANOVA: Single Factor” window opens, as shown below.Choose the first option, “ Anova: Single Factor”, and click “ OK”. Step 2: The “ Data Analysis” window opens.Step 1: Select the Data tab → go to the “ Analysis” group → click the “ Data Analysis” option.The steps to test whether the mean scores of students from the 4 different colleges are different using the Anova: Single Factor are as follows: Let us test this null hypothesis by testing the P-value using single-factor ANOVA. The null hypothesis is that there is a statistical significance between the scores of the 4 colleges. In this scenario, colleges are our independent variable, and marks are the dependent variable. We have the following top 10 student marks data from 4 colleges to compare the scores of these colleges. Sample data is used to infer the properties of the larger data set or an entire population.įor instance, students from different colleges in the city take the same exam to check if any one of the colleges is making a significant difference in the result of the examination. ANOVA is used to test different data, and identify the difference between their average. We can use the Analysis ToolPak in Excel using the following functions,ĪNOVA stands for “ Analysis of Variance”.