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 ...
Get Master Visually®: Excel® 2007 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.
