View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default 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