XL5: Incorrect Average Using Anova Two-Factor With Replication

ID: Q136220

5.00 WINDOWS kbtool

The information in this article applies to:

SYMPTOMS

In Microsoft Excel, when you use Anova: Two-Factor With Replication, the total average in the Summary table is incorrect.

CAUSE

The error occurs because Microsoft Excel adds the individual averages to get a total average instead of actually averaging them.

STATUS

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.

REFERENCES

For more information about Anova: Two-Factor With Replication, choose the search button in Help and type:

   Anova

KBCategory: kbtool KBSubcategory: xlwin

Additional reference words: 5.00 statistics

Keywords          : xlwin 
Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996