Two-Way ANOVA (Analysis of Variance) in Microsoft Excel
(Page 1 of 4 )
For those times when you need to analyze two factors simultaneously, a one-way analysis of variance (ANOVA) is not enough. That's when you need to perform a two-way ANOVA. Doing the analysis manually can take quite some time, however. This article shows you how to do it with the help of Microsoft Excel.
This is a tutorial extension of Using MS Excel for One-way Analysis of Variance. In this tutorial, you will learn how to perform two-way analysis of variance in MS Excel.
This is a more complicated analysis as compared to one-way ANOVA because it will enable you to investigate two factors simultaneously in a single experiment.
In the article linked to above (for the one way ANOVA), only one factor is investigated to determine whether it has an effect on the response (e.g. electrical resistance). A two-way factor analysis of variance is of vital importance in engineering, information technology and the academic/research field. Instead of doing two independent one-way ANOVAs, more information and efficiency is gained from doing a single experiment that investigates the effects of the two factors.
A two-way ANOVA is the simplest form of experimental design covered in more advanced topics of inferential statistics called Design of Experiments (DOE).
Next: Best practices for two-way analysis of variance >>
More Microsoft Access Articles
More By Codex-M
