Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 525

Anova: Two-Factor Without Replication

The Anova: Two-Factor Without Replication command calculates the two-

way analysis of variance with one observation for each combination of the

two factors. An analysis of variance table is created that tests for the signifi -

cance of the two factors.

Input Range

Enter the range of worksheet data you want to analyze. The range must be

contiguous, with each row and column representing a combination of the

two factors.

Labels

Indicate whether the fi rst row (or column) includes header information.

Alpha

Enter the alpha level used to determine the critical value for the F statistic.

See “Output Options” at the beginning of this section for information on

the output storage options.