If the F value > F critical value,” then we can reject the null hypothesis Null Hypothesis Null hypothesis presumes that the sampled data and the population data have no difference or in simple words, it presumes that the claim made by the person on the data or population is the absolute truth and is always right.Always frame the null hypothesis and the alternative hypothesis.You need strong ANOVA knowledge to understand things better.Next, the F value of 0.70 is less than the F critical value of 3.68, so we cannot reject the null hypothesis. If “ F value < F critical value,” we cannot reject the null hypothesis. If “ F value > F critical value,” we can reject the null hypothesis. The alternative hypothesis is that “at least one of the mean is different.” The null hypothesis is “there is no difference between scores of three students.” Then, to compare the Excel ANOVA test results, we can frame two hypotheses – the “Null hypothesis” and “Alternative hypothesis.” Now we will have a detailed “Anova: Single Factor” analysis.īefore we interpret the results of ANOVA, let us look at the hypothesis of ANOVA. Step 6: Click on “OK” to complete the calculation.Step 5: Now select the “Output Range” as one of the cells in the same worksheet.Step 4: Since we have selected the data with headers, check the box “Labels in First Row.”.Step 3: In the next window for “Input Range,” select student scores.Step 2: In the “Data Analysis” window, select the first option, “Anova: Single Factor.”.Step 1: Click on “Data Analysis ” under the Data tab.”.