The Analysis ToolPak is a Microsoft Excel add-in that is available in Excel when using Microsoft Office 2016 or newer. To use it in Excel, however, you need to load it first.
Click the Tools menu, and then click Add-Ins.
In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
If the Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it. If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
The Data Analysis ToolPak will be available in the Data tab. If it is not available, you will need to quit and restart Excel to make it visible.
Downloading Excel StatPlus for Mac
The Data Analysis ToolPak add-in is not available for Mac computers using Microsoft Office 2011 and older. The Microsoft recommendation is to use StatPlus:mac LE free of charge from AnalystSoft.
Navigate to: https://www.analystsoft.com/en/products/statplusmacle/ or click here.
Select Free Download.
Next, follow the instructions on the AnalystSoft website to download the software onto your Mac.
StatPlus:mac requires Mac OS 10.5-10.10 with Microsoft Excel 2004/2008/2011/2016 installed.
Once installed the software can be used to perform basic statistical analysis. For more information regarding StatPlus, see our Excel Tutorials on our GCU media page and select Mac Users or click here.