On the other hand, the interaction effect is not significant because its p-value (0.151) is greater than our significance level. Note that these p-values are so low that Excel uses scientific notation to represent them.

Because the p-values for both Gender and Major are less than our significance level, these factors are statistically significant. Interpreting Excel’s Two-Way ANOVA Resultsįirst, look in the P-value column in the ANOVA Source of Variation table at the bottom of the output. Change this value only when you have a specific reason for doing so.įor this example, the popup should look like this: Excel uses a default Alpha value of 0.05, which is usually a good value.This represents the number of observations per group. Under Input, select the ranges for all columns of data.From the Data Analysis popup, choose Anova: Two-Factor With Replication.Two-way ANOVA determines whether the observed differences between means provide strong enough evidence to conclude that the population means are different. The dollar amount indicates the average income for each group.

How to do an anova in excel 2017