Article ID: 920190 - View products that this article applies to.
The standard residuals that are calculated by the Analysis ToolPak regression feature are different between the following versions of Microsoft Excel:
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.
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.
Article ID: 920190 - Last Review: June 8, 2006 - Revision: 1.0