Anova two factor with replication
![Excel Anova Two Factor With Replication data table](../wp-content/easy-excel/Anova/Excel_Anova_Two_Factor_With_Replication_data_table.jpg)
![Data Analysis ribbon button Data Analysis ribbon button](../wp-content/easy-excel/Anova/Data Analysis ribbon button.png)
Select Input Range which is your data table (only numbers). In my sheet it is $A$1:$F$5. In each example (group of students) I have 3 samples. As Alpha I left default 0.05.
Anova test appears in the Output Range I defined.
Anova two factor with replication test could be useful for statistics of some sets of data. Excel does it really well.
Further reading: Anova two factor without replication How to create KPI dashboard? Interactive Charts Power Query