Written and maintained by CASRAI Editorial Board
Last updated
The Analysis ToolPak is a Microsoft Excel add-in that adds a Data Analysis command with 19 statistical and engineering tools. A search for “toolpak excel”, “toolpak in excel” or “toolpak for excel” means this same add-in. This page shows how to load it, lists all 19 tools, and links each tool to a walkthrough where one exists.
Facts about the add-in come from Microsoft’s support articles “Load the Analysis ToolPak in Excel” and “Use the Analysis ToolPak to perform complex data analysis”, read 2026-11-08.
What the Excel Analysis ToolPak is used for in research
Microsoft describes the ToolPak as an add-in for complex statistical or engineering analysis: you provide the data and parameters for each analysis, and the tool calculates and displays results in an output table. For researchers it puts t-tests, ANOVA, regression, correlation and descriptive statistics behind a menu rather than hand-built formulas.
Install or access the Analysis ToolPak (Microsoft’s official steps)
Microsoft’s article applies to Excel for Microsoft 365 (Windows and Mac), Excel 2024 (Windows and Mac) and Excel 2021 (Windows and Mac). It does not list Excel for the web.
Toolpak in Excel for Windows
- Select File > Options > Add-Ins.
- In the Manage box, select Excel Add-ins, then Go.
- In the Add-Ins available box, check Analysis ToolPak, then select OK.
- If Analysis ToolPak is not listed, select Browse to find it. If Excel says the add-in is not installed on your computer, select Yes to install it.
Toolpak for Excel on Mac
- Open the Tools menu and select Excel Add-ins.
- In the Add-Ins available box, check Analysis ToolPak, then select OK.
- If it is not listed, select Browse. If told it is not installed, select Yes.
- Quit and restart Excel.
After loading, the Data Analysis command appears on the Data tab. To use the ToolPak’s VBA functions, also check Analysis ToolPak – VBA in the same dialog. If the ToolPak does not support your language, it displays in English.
Step by step: run a tool from Data Analysis
- Put your data on one worksheet, in columns or rows.
- Select Data > Data Analysis.
- Choose a tool from the list (all 19 are in the table below) and select OK.
- Fill in the dialog: input range, output location and the tool’s own options.
- Select OK. Excel writes the results at the location you chose.
The ToolPak works on one worksheet at a time. If you analyse data on grouped worksheets, results appear on the first worksheet only. To analyse each sheet, ungroup them and repeat the tool for each one.
All 19 Analysis ToolPak tools and where to learn each
| Tool (name in the Data Analysis list) | CASRAI walkthrough |
|---|---|
| Anova: Single Factor | ANOVA in Excel |
| Anova: Two-Factor With Replication | ANOVA in Excel |
| Anova: Two-Factor Without Replication | ANOVA in Excel |
| Correlation | Correlation coefficient in Excel |
| Covariance | Covariance matrix (concept) |
| Descriptive Statistics | Excel statistics functions |
| Exponential Smoothing | Described by Microsoft; no CASRAI walkthrough |
| F-Test Two-Sample for Variances | F-test in Excel |
| Fourier Analysis | Described by Microsoft; no CASRAI walkthrough |
| Histogram | Histograms in Excel |
| Moving Average | Described by Microsoft; no CASRAI walkthrough |
| Random Number Generation | Described by Microsoft; no CASRAI walkthrough |
| Rank and Percentile | Described by Microsoft; no CASRAI walkthrough |
| Regression | Described by Microsoft; no CASRAI walkthrough |
| Sampling | Described by Microsoft; no CASRAI walkthrough |
| t-Test: Paired Two Sample for Means | t-test in Excel |
| t-Test: Two-Sample Assuming Equal Variances | t-test in Excel |
| t-Test: Two-Sample Assuming Unequal Variances | t-test in Excel |
| z-Test: Two Sample for Means | Described by Microsoft; no CASRAI walkthrough |
Microsoft describes Regression as a least-squares analysis and the z-test as the two-sample test for means when variances are known. Before choosing a parametric tool, see normality testing in Excel.
Output and how to read it
Each tool writes its results to the output range you chose. Match the headings in the output to the test you meant to run, and compare any p-value with your pre-set significance level (see p-value). The walkthroughs in the table explain the output of the tests they cover.
Several tools are built on worksheet functions. Microsoft names three: Regression uses LINEST, Rank and Percentile uses RANK.EQ and PERCENTRANK.INC, and Covariance uses COVARIANCE.P. Knowing this tells you which definition the tool applies; COVARIANCE.P, for instance, is the population covariance.
Troubleshooting the Data Analysis command
Data Analysis is missing from the Data tab
The add-in is not loaded. Repeat the loading steps above and confirm Analysis ToolPak is checked.
Analysis ToolPak is not in the Add-Ins list
Select Browse to locate it. If Excel reports it is not installed, answer Yes to install it.
It does not appear on a Mac
Quit and restart Excel after checking the add-in; Microsoft lists the restart as part of the steps.
VBA functions are not available
Also check Analysis ToolPak – VBA in the Add-Ins dialog.
Results appear only on the first sheet
Your worksheets are grouped. Ungroup them and run the tool on each sheet in turn.
You use Excel for the web
Microsoft’s loading article covers Excel for Microsoft 365, 2024 and 2021 on Windows and Mac, and does not list Excel for the web.
Alternatives that stay inside Excel
Microsoft’s article names the worksheet functions that three tools rely on, so you can call them directly in cells.
| ToolPak tool | Worksheet function named by Microsoft |
|---|---|
| Regression | LINEST |
| Rank and Percentile | RANK.EQ and PERCENTRANK.INC |
| Covariance | COVARIANCE.P |
For more built-in functions, see Excel statistics functions.
FAQ
What is the Excel ToolPak?
It is Microsoft’s Analysis ToolPak, an Excel add-in that provides the Data Analysis command with 19 statistical and engineering tools.
Where is the toolpak in Excel?
Once loaded, the Data Analysis command is on the Data tab. If it is not there, load the add-in via File > Options > Add-Ins (Windows) or Tools > Excel Add-ins (Mac).
How do I get the toolpak for Excel on a Mac?
Tools > Excel Add-ins, check Analysis ToolPak, select OK, then quit and restart Excel.
How many tools does the ToolPak include?
Nineteen, listed in the table above, per Microsoft’s support article.
Sources
- Microsoft Support, Load the Analysis ToolPak in Excel, read 2026-11-08.
- Microsoft Support, Use the Analysis ToolPak to perform complex data analysis, read 2026-11-08.
