The standard residuals that are calculated by the Analysis ToolPak regression feature are different between Excel 97 and Excel 95 (920190)


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000
  • Microsoft Excel 97 for Windows

SYMPTOMS

The standard residuals that are calculated by the Analysis ToolPak regression feature are different between the following versions of Microsoft Excel:
  • Microsoft Excel 97 for Windows and later versions of Excel
  • Microsoft Excel 95 and earlier versions of Excel

CAUSE

This issue occurs because Excel 97 and later versions of Excel standardize on a definition of variance that does not consider bias in the sample set.

STATUS

This behavior is by design.

MORE INFORMATION

In regression analysis, the residual is the difference between the value that is predicted by the regression formula and the actual value that is measured. The standardized residuals have been adjusted to make sure that they have a standard deviation of 1.
Modification Type:MajorLast Reviewed:6/8/2006
Keywords:kbAddIn kbExpertiseBeginner kbtshoot kbprb KB920190 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.