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

Each day business users everywhere gather, manipulate and report information using Microsoft Office applications. But in most cases, the data that is needed for analyses and reports originates in, or is analyzed by, systems and applications outside of the Microsoft Office suite. Business analysts frequently need access to large data sources that exceed the limitations of Microsoft Office tools.
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