two way anovaUse two-way ANOVA to assess differences between the group means that are defined by two categorical factors.Steps :- Click Data Analysis on the Data tab.
- From the Data Analysis popup, choose Anova: Two-Factor With Replication.
- Under Input, select the ranges for all columns of data.
- In Rows per sample, enter 5. This represents the number of observations per group.
- Excel uses a default Alpha value of 0.05, which is usually a good value. Alpha is the significance level.
- Click OK.