How to interpret two-way anova results 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.

When interpreting the results of a one-way ANOVA, it can be helpful to create a graph to visualize the difference between the group means.

The following example shows how to perform a one-way ANOVA and graph the results in Excel.

Example: How to Graph ANOVA Results in Excel

Suppose a professor randomly assigns 30 students in her class to use one of three studying methods to prepare for an exam.

The following screenshot shows the scores of the students based on the method they used:

Suppose the professor wants to perform a one-way ANOVA to determine if the mean scores are the same across all three groups.

To perform a one-way ANOVA in Excel, click the Data tab along the top ribbon, then click Data Analysis within the Analyze group.

If you don’t see the Data Analysis option, then you need to first load the free Analysis ToolPak.

In the new panel that appears, click Anova: Single Factor