Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Input Range Error Using Anova Analysis Tool

XL2000: Input Range Error Using Anova Analysis Tool

View products that this article applies to.

This article was previously published under Q212089

↑ Back to the top

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

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB212089, kbprb

↑ Back to the top

Article Info
Article ID : 212089
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 248