Search This Blog

Tuesday, May 19, 2020

Calculate a Two Way ANOVA without Replication in Excel

If you're familiar with a one way ANOVA, then a two way (or two factor) ANOVA is not to different. What you're trying to do is compare the difference between two independent variables (or factors) to see if the interaction between the two factor affect each other. Excel gives you an easy way to calculate this ANOVA with the Data Analysis toolpak...but I'll also show you how to perform them manual calculations to see how Excel gets it's answers.

No comments:

Post a Comment