XL5: Incorrect Average Using Anova Two-Factor With Replication |
In Microsoft Excel, when you use Anova: Two-Factor With Replication, the total average in the Summary table is incorrect.
The error occurs because Microsoft Excel adds the individual averages to get a total average instead of actually averaging them.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows version 5.0c.
For more information about Anova: Two-Factor With Replication, choose the search button in Help and type: Anova
Additional query words: statistics
Keywords : xlwin
Version : WINDOWS:5.0
Platform : WINDOWS
Issue type :
Technology :
|
Last Reviewed: October 6, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |