Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 10 Analysis of Variance 399

Figure 10-6
The Anova:
Single Factor
dialog box

5 Click OK.

Figure 10-7 shows the resulting analysis of variance output, with

some minor formatting.

Figure 10-7

Analysis

of variance

output

Interpreting the Analysis of Variance Table

In performing an analysis of variance, you determine what part of the vari-

ance you should attribute to randomness and what part you can attribute

to other factors. Analysis of variance does this by splitting the total sum of