There is a known issue in the Analysis ToolPak of Microsoft Excel 2007. The Regression tool in the Analysis ToolPak in Excel 2007 does not display residual and line fit plots correctly. For more information on this problem please see: http://itinfo.mit.edu/article.php?id=8494

This issue has been documented to Microsoft and a hotfix is currently being developed for release by the end of September 2007. In the meantime, a work around has been implemented for users who need to use the Regression Tool.
Read the rest of this entry »