XL97: Input Range Error Using Anova Analysis Tool

 Last reviewed: January 7, 1998
Article ID: Q173554
The information in this article applies to:
  • Microsoft Excel 97 for Windows

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 earlier versions of Excel. Microsoft Excel versions 5.0 and 7.0 allow empty cells in the input range. The Anova analysis tool in Excel 97 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: XL97 covariance
Keywords : xladdins
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 7, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.