One-way analysis of variance, or ANOVA, is a test used to determine whether the population means of a dependent variable like heart rate are different from each other at different levels of an independent variable, like temperature. Two-way ANOVA adds a second factor, like humidity, and three-way adds a third factor such as weight. In each test, the null hypothesis is that the means of the dependent variable are the same, and the alternative hypothesis is that they are different. Two- and three-way ANOVA tests also add the interaction between the factors. ANOVA with replication means that, for each combination of variables, you have taken two or more measurements. Excel can only run up to two-way ANOVA; you would need a more advanced program like Minitab, SAS or SPSS to do so. However, you can use a regression equation with three factors in Excel to approximate the results of a three-way ANOVA test with replication. Tips Warnings Writer Bio
