The Data Analysis ToolPak is an Excel add-in that enables Excel to do some statistical calculations automatically. As you move through the tutorials on this site, you will see that our Excel examples frequently utilize the ToolPak.
The ToolPak is available for all recent PC versions of Excel (2007, 2013, 2016) and in the newest Mac version, Excel 2016. It is not available for previous versions of Excel for Mac. See below for instructions to on how to enable the Data Analysis ToolPak on your computer:
Installing the Data Analysis ToolPak
The list of available functions are:
Anova: Single Factor | Anova: Two-Factor with Replication | Anova: Two-Factor Without Replication | Correlation |
Covariance | Descriptive Statistics | Exponential Smoothing | F-Test Two Sample for Variance |
Fourier Analysis | Histogram | Moving Average | Random Number Generation |
Rank and Percents | Regression | Sampling | t-Test: Paired Two Sample for Means |
t-Test: Two-Sample Assuming Equal Variances | t-Test: Two-Sample Assuming Unequal Variances | Z-Test: Two-Samples for Mean |