Microsoft KB Archive/147939

= Microsoft Knowledge Base =

XL: Help Topic for PEARSON Function Is Incorrect
Last reviewed: September 13, 1996

Article ID: Q147939

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0, 5.0c
 * Microsoft Excel for Windows 95, version 7.0
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SUMMARY
There is a documentation error in the PEARSON function Help topic in the versions of Microsoft Excel listed above. In the remarks section of the Help topic, the formula listed for the "r value of the regression line" is incorrect.

MORE INFORMATION
The correct formula that is used for the "r value of the regression line" can be found in either of the following reference books:

 "Microsoft Excel Function Reference," version 4.0 -or- "Microsoft Excel 5 Worksheet Function Reference" Microsoft Press ISBN: 1-55615-637-5

Microsoft Press books can be found in most local bookstores, or ordered directly from Microsoft Press at (800) MSPRESS.