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:


Click the Office button and then click the Excel Options button.

The Excel Options dialog box opens.


Click 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.


Select Excel Add-Ins from the Manage drop-down list (at the bottom) and click Go.

Excel opens the Add-Ins dialog box.


Select 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.


If an alert dialog box asking you if you want to install the add-in appears, click Yes.

Because add-ins often contain macros, and macros can open up your computer to malicious attacks, Microsoft has raised security level surrounding add-ins.

After you load the Analysis ToolPak in this manner and the installation completes, the features are available for your use. For example, you can access the statistical analysis tools by clicking the Data Analysis button in the Analysis group added to the end of the Ribbon’s Data tab. When you choose this command, Excel opens the Data Analysis dialog box. Select a tool and click OK.

For general help with the function and use of the various statistical analysis tools added by the Analysis ToolPak, click the Help button (the one with the question mark) in the Data Analysis dialog box.