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 »

• 0 Comments

Microsoft Excel spreadsheets have become somewhat of a standard for data storage, at least for smaller data sets. This, along with the program often being packaged with new computers, naturally encourages its use for statistical analyses. This is unfortunate, since Excel is most decidedly not a statistical package.
Read the rest of this entry »

• 0 Comments