Microsoft Office Development and Consultancy

Excel

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.

Add-in Location

Excel 2010 - C:\Program Files\Microsoft Office\Office14\Library\Analysis\ATPVBAEN.XLAM | FUNCRES.XLAM | ANALYS32.DLL

Excel 2007 - C:\Program Files\Microsoft Office\Office12\Library\Analysis\ATPVBAEN.XLAM | FUNCRES.XLAM | ANALYS32.DLL

Excel 2003 - C:\Program Files\Microsoft Office\Office11\Library\Analysis\ATPVBAEN.XLAM | FUNCRES.XLAM | ANALYS32.DLL

Installing Analysis-ToolPak

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

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.

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 ….

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.