Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
524

Anova: Two-Factor With Replication

The Anova: Two-Factor With Replication command calculates the two-way
analysis of variance with multiple observations for each combination of the
two factors. An analysis of variance table is created that tests for the signifi -
cance of the two factors and the signifi cance of an interaction between the
two factors.

Input Range


Enter the range of worksheet data you want to analyze. The range must be
rectangular, the columns representing the fi rst factor and the rows repre-
senting the second factor. An equal number of rows are required for each
level of the second factor.

Rows per Sample


Enter the number of repeated values for each combination of the two factors.

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.
Free download pdf