ANOVA with 3 factors

C

Confused Slug

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

Thanks
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ANOVA with two factors 2
Cumulative formula for word table 0
Tukey HSD tests 0
Anova tests in excel 0
1 way ANOVA 0
Fisher statistical law 4
two-way ANOVA 2
Look up with 2 factors 1

Top