ANOVA with 3 factors
 

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

Thanks

ANOVA with 3 factors
 

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


"Confused Slug" wrote in message
...
Is it possible to using Excel to perform an ANOVA with 3 (or more) factors?

Thanks