Excel - ANOVA with 3 factors

Asked By Confused Slug on 17-Feb-10 10:44 AM
Is it possible to using Excel to perform an ANOVA with 3 (or more) factors?

Thanks




Mike Middleton replied to Confused Slug on 17-Feb-10 02:26 PM
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 are 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 are 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
F Poscic replied to Confused Slug on 03-Jun-11 01:56 PM
You can use this nice file:



http://filip-updates.blogspot.com/2011/05/amazing-anova-three-factors-for-excel.html