Excel Analysis Toolpak Guide How to Add and Install

In this tutorial, we will learn what is Excel Analysis Toolpak, as well as where we can find it. Along with we will know how to activate and install it on our Windows and Mac.

Excel data analysis toolpak

The analysis toolpak is an Excel add-in providing tools for complex data analysis. Primarily its role is to remove those detailed steps in executing certain calculations.

The good thing even if you know those detailed steps, it’s a time saver in doing a task.

Furthermore, this tool is a great help if you are having engineering or statistical data to analyze. And even use this Analysis Toolpak in applying techniques you prefer, such as generating analyze output table, summarizing or simplifying data.

For instance, if you already know what is the appropriate engineering or statistical function of data. Hence select the Tool from Excels Toolpak. Accordingly, the results will be shown on the output table and others is generated in both charts and output table.

Where is the Analysis Toolpak in Excel

Analysis toolpak in Excel if activated can be found in Data Tab. Then under analyze group command, you’ll find it. But if not we will show you how to add this to your ribbon.

Analysis toolpak

How to add Analysis Toolpak in Excel

Here are the steps to add Analysis Toolpak in Excel.

  1. First, on the File tab click it then find and click Options.


  2. When the dialog box appears, click the Add-Ins in the Excel options category on the left. However, when still using Excel 2007, go to Microsoft Office Button and click it, and then click Excel Options.

    Excel Add-ins

  3. In add-ins dropdown list, select the preferred add-ins then Click GO. In our case, we select Analysis toolpak.

    Select analysis toolpak

  4. And now in the Add-Ins dialog box, check the Analysis ToolPak check box, then click OK.

    Check Analyis toolpak


  • However, if the Analysis Toolpak is not available in list of add-ins, click the browse command to find it.
  • And if not installed on the computer click YES to install it.

How to use Analysis Toolpak in Excel

Here are the analytical tools you can use along with their purposes.

ANOVA: Single FactorThis tool determines a simple analysis of variance between the relationship of two data sets.
ANOVA: Two Factor with ReplicationThis tool is used to determine if there is a relationship between two datasets and classified into two different dimensions.
Anova: Two-Factor without ReplicationThis tool determines the usefulness when data is categorized on two different measurements as in the Two-Factor case With Replication.
CorrelationThis tool was used in more than two variable measurements of every N subject.
CovarianceThis analysis tool is used to calculate the average product deviation value from the mean of the data set.
Descriptive StatisticsCreate a report of univariate statistics for the selected data.
Exponential SmoothingSmooths out irregularities (peaks and valleys) in data, to easily recognize trends. More recent data is weighted more heavily.
F-Test Two Sample for VariancesThis analysis tool compares the variances between two groups of data. 
Fourier AnalysisThis tool using Fast and Fourier Transform solves problems in linear systems and analyzes periodic data and transforms data.
HistogramThe Histogram analysis tool is used to show the distribution of values in specified ranges.
Moving AverageCalculates a moving average to allow you to smooth out a data series that contains peaks and outliers.
Random Number GenerationCreates a number of several types of random numbers including Uniform, Normal, Bernoulli, Poisson, Patterned and Discrete.
Rank and PercentileCreates a table which ranks numbers from highest to lowest and provides a percentile value of each number relative to the other numbers within the data set.
RegressionThis uses LINEST function to determine if the single dependent variable is affected by the values of one or more independent variables.
SamplingIt is a sample population, either random or periodic.
t-Test: Paired Two Sample for MeansPaired two-sample student’s T-Test. Each Two-Sample t-Test analysis tool tests for equality of the population means that underlie each sample.
T-Test: Two Sample assuming equal VariancesIt is used to test data to see if there is statistical significance or if the results may have occurred randomly.
T-Test: Two Sample assuming unequal VariancesThis t-Test form assumes that the two datasets are from distributions where the variances are unequal. This is called a “heteroscedastic t-Test”.
Z-Test: Two Sample for MeansTwo-sample Z-test for is a statistical hypothesis testing technique that is used to determine if the difference between the two population means is not statistically significant.

How to add Analysis Toolpak in Excel Mac

To load Analysis Toolpak in Excel Mac, all you have to do is the following:

First, on the Tools menu click then find and click Excel add-ins on the list.

mac add-ins

Whenever the Excel add-in dialog box appears, check the Analysis ToolPak check box, and then click OK.

Add-ins MAc
Add-ins MAc

If Analysis ToolPak is not shown in the Add-Ins available box, click the Browse command to find it.

How to install Analysis Toolpak in Excel

Here are the following steps you can consider in installing Analysis toolpak in your Excel 2016/2019:

  • Click your File Tab.
  • Find and Click Option. Then the options dialog box will display.
  • Select Add-Ins. It locates on the left category.
  • Then locate and click Analysis ToolPak.
  • At the bottom part, you will see the manage drop-down. Choose Excel-Add-ins and click the Go button.
  • Another dialog box will and all available Add-ins will be displayed. Check Analysis Toolpak and click OK.
  • Your analysis ToolPak is already loaded now. You see on the Data tab under the analysis group of command.


In conclusion, the article Analysis toolpak of Microsoft Excel can be activated through the given guide. Besides that, this analysis toolpak we can find in data analysis is a great help in analyzing data. Especially statistical and engineering datasets.

I hope this tutorial helps you in doing your worksheets and analyzing data.

Thank you for reading 🙂

Leave a Comment