Microsoft KB Archive/173554: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
| Line 44: | Line 44: | ||
== SYMPTOMS == | == SYMPTOMS == | ||
When you use | When you use "Anova: Two-Factor Without Replication" in the Data Analysis tools, you may receive the following error message: | ||
<div class="errormessage"> | <div class="errormessage"> | ||
| Line 84: | Line 84: | ||
</div> | </div> | ||
and then double-click the selected text to go to the | and then double-click the selected text to go to the "Perform an analysis of variance (anova)" topic. | ||
</div> | </div> | ||
Latest revision as of 11:06, 21 July 2020
Article ID: 173554
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q173554
SYMPTOMS
When you use "Anova: Two-Factor Without Replication" in the Data Analysis tools, you may receive the following error message:
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, because Excel is substituting zeroes for empty values when the calculations are performed.
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: kbprb KB173554
