XL98: Input Range Error Using Anova Analysis Tool

ID: Q178409

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

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.

REFERENCES

For more information about the Anova analysis tool, click the Index tab in Help, type the following text

Anova tool

and then double-click the selected text to go to the "Perform an analysis of variance (anova)" topic.

Additional query words: XL98 covariance

Keywords : xladdins
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb