Learn about Analysis ToolPak and How to Activate

Learn about Analysis ToolPak and How to Activate
  • Post published:November 2, 2019
  • Post author:
  • Post last modified:April 26, 2020
  • Reading time:2 min(s) read

Analysis ToolPak is a very powerful Microsoft Excel add-in which has a pack of tools you can use to do data analysis tasks such as ANOVA test, descriptive statistics, generating histograms and regression analysis. Total of nineteen analysis tool are there in this add-in that comes with the latest Microsoft Excel version which Excel 2019.

Data Analysis Tool Pack
Excel Data Analysis Tool pack

So where is this data analysis toolpak in Excel ?

The command button to launch Analysis Tool-Pak generally located under “Data” tab in the ribbon. If you could not find it there, you will have to activate it.

Data Analysis Button

How to activate Analysis Toolpak in Excel ?

Step 01

Go to → File Option

In the popped up “Excel Options” dialog box,
Click “Add-ins” from the menu located left of the dialog box.
ow you can see all the add-ins currently available and the “Analysis ToolPak” add-in is listed under “Inactive Application Add-ins”.

activate analysis toolpak add in

Step 02

Select “Excel Add-ins” from the drop-down menu labeled “Manage”, which is located bottom of the “Excel Options” dialog box.
Then Click “Go”.
Now the “Add-ins” dialog box will be popped up. It has all the add-ins available listed with check boxes in front of them.

Step 03

check analysis toopak
Check Analysis ToolPak Add-in

Select the check box for “Analysis ToolPak”
Then click “OK”.
Now go to “Data” tab in the ribbon. If you have done everything right you should see the “Data Analysis” command under “Analysis” group.

We will discuss how you can analyze data using tools available in this add-in in next tutorials.

Leave a Reply