Excel Analysis ToolPak: How to Enable It and Which Tool to Use

Updated on Mon Oct 12 2026

To turn on the Analysis ToolPak in Excel for Windows: go to File › Options › Add-ins, choose Excel Add-ins in the Manage box, click Go, tick Analysis ToolPak and click OK. The Data Analysis button then appears at the right end of the Data tab.

The ToolPak is a free add-in that comes with Excel. It has 19 statistics tools, including descriptive statistics, histograms, t-tests, ANOVA and regression.

Turn on the Analysis ToolPak

Pick your Excel for the exact steps.

File › Options › Add-ins.
At the bottom, set Manage to Excel Add-ins and click Go…
Tick Analysis ToolPak and click OK.
The button appears at Data › Analysis › Data Analysis.

Not in the list? Click Browse and look in the Office Library\Analysis folder, or repair Office from Windows Settings › Apps. Analysis ToolPak - VBA is only needed if macros call the ToolPak.

Which tool do you need?

Pick what you want to do. Each tool lists the worksheet function that gives the same answer and updates when the data changes (ToolPak output is static).

Where is the Data Analysis button?

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.

How to activate the Analysis ToolPak in Excel for Windows

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.
Now you can see all the add-ins currently available and the “Analysis ToolPak” add-in is listed under “Inactive Application Add-ins”.

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

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.

Next, try a tool. The regression analysis tutorial walks through the Regression tool from start to finish.