There is a free add-in called the Analysis Toolpak for Excel. The instructions on how to load it are below, pulled from: Load the Analysis ToolPak in Excel Follow these steps to load the Analysis ToolPak in Excel 2016 for Mac: 1. Click the Tools m.
Related articles:
Load more
The Analysis ToolPak is an Excel 2007 add-in program that adds extra financial, statistical, and engineering functions to Excel’s pool of built-in functions. The tools included in the Analysis ToolPak enable you to analyze worksheet data by using such things as ANOVA, F-Test, rank and percentile, t-Test, and Fourier analysis.
Although the Analysis ToolPak comes with EXcel 2007, it doesn’t come pre-installed. Before you can use the statistical functions added by the Analysis ToolPak, you must install and load it as follows:
1Click the Office button and then click the Excel Options button.
![Pro Pro](http://i.ytimg.com/vi/ywVPsTNv8zY/maxresdefault.jpg)
The Excel Options dialog box opens.
2Click the Add-Ins tab in the left pane.
The Add-Ins tab contains a list of all the add-in programs installed on your computer.
3Select Excel Add-Ins from the Manage drop-down list (at the bottom) and click Go.
Excel opens the Add-Ins dialog box.
4Select the Analysis ToolPak check box in the Add-Ins dialog box and then click the OK button.
You might find some other interesting add-ins there, too.
5If an alert dialog box asking you if you want to install the add-in appears, click Yes.
![Toolpak Toolpak](https://i.ytimg.com/vi/NbjzrobOG7k/maxresdefault.jpg)
Because add-ins often contain macros, and macros can open up your computer to malicious attacks, Microsoft has raised security level surrounding add-ins.