Leading the way in Microsoft Office Development

What is Analysis ToolPak ?

The Analysis ToolPak add-in is a third party Excel add-in that provides special analysis tools suitable for medium scale statistical analysis.

This add-in provides 96 additional worksheet functions as well as some complicated analysis techniques.

The Analysis ToolPak add-in should not be installed unless you are going to use either the additional worksheet functions or the Data Analysis functionality as Excel will take slightly longer to open with this add-in installed.

Installing Analysis ToolPak

To install the Analysis ToolPak add-in select (Tools > Add-ins), select "Analysis ToolPak" and press OK.

 (Tools > Add-ins) dialog box

For more details on how to install an Excel add-in, please refer to the Add-ins section.

When this add-in is installed you will see an additional "Data Analysis" button added to the bottom of your (Tools) drop-down menu.

 (Tools > Data Analysis) drop-down menu

The additional worksheet functions are added to 4 of the existing categories and a brand new Engineering category is added.

These functions are added to the Date and Time, Financial, Information and Maths and Trigonometry categories.

For a list these additional functions please refer to the main Analysis ToolPak section page.

Data Analysis

Once you have the Analysis ToolPak add-in installed an extra command will appear at the bottom of the (Tools) drop-down menu.

This will give you a choice of ….

 (Tools > Data Analysis) dialog box

Things to Remember

If you try to use any of these functions without the add-in installed the function will return the #NAME? error.

There are actually two possible add-ins that can be installed relating to Analysis ToolPak.

The add-in called Analysis ToolPak - VBA is only needed if you are going to call the worksheet functions from VBA.