O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 26. Performing Advanced Statistical Analyses

Calculate Anova

You can calculate single-factor Anova, two-factor Anova with replication, and two-factor Anova without replication by using tools available in the Analysis ToolPak add-in that comes with Excel. To perform any of these calculations, you need to install the Analysis ToolPak add-in; see Chapter 28 for more.

Anova is the analysis of variance tool that performs a statistical test to determine whether two or more statistical samples were drawn from the same population. If you are comparing only two samples, you can use the TTEST function, but if you are comparing three or more samples, you will want to use the Anova tools in the Analysis ToolPak. This section assumes that you understand ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required