ANOVA with 3 factors

[Confused Slug]

Is it possible to using Excel to perform an ANOVA with 3 (or more) factors?

Thanks

 

[Mike Middleton]

Confused Slug -

The Data Analysis wizards of Excel's Analysis ToolPak have only one-factor
and two-factor ANOVA.

For three-factor ANOVA, you could investigate using Minitab, SPSS, SAS, or
R.

Or, depending on your needs, you might be able to Excel's Regression tool or
LINEST worksheet function if you're willing to set up the data matrix of
binary indicator variables. Both the Regression tool and LINEST are limited
to sixteen explanatory variables, so you're limited to four-factor ANOVA if
you want to include all interaction terms.

- Mike
http://www.MikeMiddleton.com


Is it possible to using Excel to perform an ANOVA with 3 (or more) factors?

Thanks