XL2000: Input Range Error Using Anova Analysis Tool (212089)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q212089

SYMPTOMS

When you use the Anova: Two-Factor Without Replication tool in the Data Analysis ToolPak, you may receive the following error message:
Anova: Two-Factor Without Replication - Input range contains non-numeric data

CAUSE

This behavior can occur when the input range contains either empty cells or text.

WORKAROUND

To work around this issue, type a value of 0 (zero) into the empty cells in the input range. Doing so has no significant effect on the variation of the data.

MORE INFORMATION

This behavior differs from earlier versions of Microsoft Excel. Excel 5.0 and 7.0 allow empty cells in the input range. The Anova analysis tool in Excel 2000 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 Microsoft Excel Help on the Help menu, type perform an analysis of variance (anova) in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb KB212089
©2003 Microsoft Corporation. All rights reserved.