Microsoft Office Development and Consultancy
|Excel > Analysis ToolPak > Getting Started||| Next >|
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 a number of additional analysis techniques.
This add-in should not be installed unless you are going to use the additional Data Analysis functionality as Excel will take slightly longer to open with this add-in installed.
In Excel 2003 this add-in also provided additional worksheet functions, although in Excel 2007 these were included as standard.
Excel 2013 - ??
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
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 "Analysis" group added to the end of your Data tab.
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.
Once you have the Analysis-ToolPak add-in installed an extra button will appear at the on the far right of your Data tab.
This will give you a choice of the following analysis tools:
Things to Remember
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.
In Excel 2003 if you try to use any of these functions without the add-in installed the function will return the #NAME? error.
|© Better Solutions Limited 06-Dec-2013||Top | Next >|