Regression Analysis Add-Ons for Excel

Microsoft Excel is a powerful spreadsheet programs that has a lot of powerful built-in functions, but none for regression analysis for predictive analytics. Fortunately, Excel is also powerful in that it can be expanded, using add-ins, adapting the program to the needs of the user. Those who work regularly with statistics will benefit from the availability of a regression analysis add on for Microsoft Excel. Five of these are listed here.

The most common regression analysis add on for Microsoft Excel is the Analysis ToolPak. This is an add-in that can be installed from your Microsoft Office CDROM. If you have Microsoft Office Excel 2007, you can tell if you have the Analysis ToolPak installed by clicking the Office button and then the “Excel options” button. In the “Excel Options” window, click “Add-ins” on the left. On the “Add-Ins” panel, select “Excel Add ins” from the combo box and click the “Go” button. In the Add-Ins window, see if “Analysis ToolPak is checked.

If it isn’t, click on the box and Excel will attempt to install it. You will be prompted to insert you Microsoft Office CDROM as the program works to install the add on. With the Analysis Tool Pak installed, you now can perform regression analysis by clicking on the “Regression” option from the “Data Analysis” window.

Another regression analysis add on for Excel is SolverStat. This add-in addresses weaknesses found in Microsoft Excel's Solver function, part of the Analysis ToolPak. Solver doesn't offer the estimated precision of fitted parameters and is also faulted for inadequate (and sometimes superfluous) analysis of fittings. SolverStat enhances functions to solve linear and non-linear regression problems, providing steps that provide analysis for model reliability. This add-in also performs statistical tests on least squares regression data.

Unlike Excel’s Analysis ToolPak regression analysis add on, OLS Regression works with values that aren’t present. It performs OLS estimation in excess of the 16 Xs that limit the LINEST function in Excel. OLS Regression compliments normal regression output with robust SEs. The add-in also installs a function; OLSReg, which is equivalent to LINEST, but presents a more readable format.

StatTools is a complete statistical tool kit for use in Microsoft Excel. It supports robust regression analysis and seamless integration with

click to enlarge

Analyse-it provides statistical analysis and charting capabilities for Microsoft Excel. Scientists, engineers, educators, and manufacturing specialists will all find the power of Analyse-It’s regression analysis add on and more than 29 other non parametric and parametric procedures offers the tools necessary to uncover trends, investigate options for decision-making, and identify variations in datasets.