Microsoft KB Archive/178409

= XL98: Input Range Error Using Anova Analysis Tool =

Article ID: 178409

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q178409



SYMPTOMS
When you use "Anova: Two-Factor Without Replication" in the Data Analysis tools, you may receive the following error message:

Anova: Two-Factor Without Replication - Input range contains non-numeric data



CAUSE
This problem occurs when the input range contains either empty cells or text.



WORKAROUND
To work around this problem, enter a value of zero (0) into the empty cells in the input range. This has no significant effect on the variation of the data.



MORE INFORMATION
This behavior differs from the earlier version of Excel. Microsoft Excel version 5.0 allows empty cells in the input range. The Anova analysis tool in Excel 98 does not work unless you remove the empty cells in the input range or replace them with values.

