O'Reilly logo

Master Visually®: Excel® 2007 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 28. Performing Advanced Statistical Analysis

Calculate Anova

You can calculate single-factor Anova, two-factor Anova with replication, and two-factor Anova without replication 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 "Enable Excel Add-Ins" in Chapter 30 for more details.

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 two or more samples, you can use the Anova tools in the Analysis ToolPak. This section assumes ...

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