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 ...

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.