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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
