Amazing! AnOVa three factors for excel 2007!

AnOVa (Analysis Of Variance) provides a statistical test of whether or not the means of several groups are all equal, and therefore generalizes t-test to more than two groups. In one way AnOVa you compare only one factor while in two or more ways you compare means of several groups through many factors. For example one can be interested if there is any difference between the measured variable (the dependent variable) in several populations (first factor or way - i.e. the first indipendent variable) through different toxic concentrations (second factor or way - i.e. the second indipendent variable).

Several programs can compute AnOVa but most of them are not free (SPSS, Statistica, SAS). On the other hand Past is a very useful free statistic package. However this program can only compute AnOVa till two factors. Excel doesn't provide a full statistic package for AnOVa - only for one way.

The file AnOVa for excel its my new creation and it is very useful expecially if the users can not access not free proprietary software and need three factors AnOVa.

The output of my AnOVa for excel

AnOVa for excel has the following good features:

• it's free;
• it's open source;
• it's in a friendly excel;
• it can compute till three factors and even more if you have a little bit of patience and work on the source;
• it has a clar instructions.

So enjoy! Download it here.