Here’s how to interpret the values in each table: There are two tables that are shown in the output: SUMMARY and ANOVA. Once you click OK, the results of the one-way ANOVA will appear:

In the new window that appears, enter the following information: Select Anova: Single Factor, then click OK. Once you click this, a new window will appear. If you don’t see the Data A nalysi s option, then you need to first load the free Analysis ToolPak. To perform a one-way ANOVA in Excel, click the Data tab along the top ribbon, then click Data Analysis within the Analyze group. Suppose the teacher wants to perform a one-way ANOVA to determine if the mean scores are the same across all three groups. The following screenshot shows the scores of the students based on the method they used: Suppose a teacher randomly assigns 30 students in her class to use one of three studying methods to prepare for an exam.

Example: How to Interpret ANOVA Results in Excel

The following example provides a complete guide on how to interpret the results of a one-way ANOVA in Excel. An one-way ANOVA is used to determine whether or not there is a statistically significant difference between the means of three or more independent groups.

How to do an anova in excel 2007