Using the Analysis Toolpak Data Analysis Tools
The Analysis Toolpak add-in is part of the deal when you purchase Excel 2007, although you might not know it. Add-ins are little packages of tools that more or less seamlessly integrate into the user interface of Excel. However, they require you to install them first. The following sections discuss the installation of, and the tools included with, the Analysis Toolpak.
Installing the Analysis Toolpak
To see whether you have the Analysis Toolpak installed, click the Data tab on the Ribbon. If the Data Analysis button is there, then you’re good to go. If not, click the Microsoft Office Button, click Excel Options, and select the Add-Ins category. In the Manage list at the bottom of the dialog box, select ...