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.

The Covariance analysis tool returns a different value in Excel 2000 than it does in Excel 97


View products that this article applies to.

This article was previously published under Q215706

↑ Back to the top


Symptoms

Using the same data in each case, the Microsoft Excel 2000 Covariance analysis tool returns a different value than does the same tool in Excel 97.

↑ Back to the top


Cause

This behavior occurs because Excel 97 incorrectly uses 1/(1-n) instead of 1/n in the covariance equation. Excel 2000 correctly uses 1/n.

↑ Back to the top


Resolution

The value returned by the Covariance analysis tool in Excel 2000 is the correct value.

↑ Back to the top


Status

This problem was corrected in Excel 2000.

↑ Back to the top


More information

The Covariance analysis tool is part of the Analysis ToolPak add-in.

↑ Back to the top


References

For more information about the Covariance analysis tool and its formula, click Microsoft Excel Help on the Help menu, type covariance in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top


Keywords: KB215706, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 215706
Revision : 6
Created on : 12/1/2004
Published on : 12/1/2004
Exists online : False
Views : 310