Using the Analysis Toolpak Data Analysis Tools
The Analysis Toolpak add-in is part of the deal when you purchase Excel 2010, 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, you’re good to go. If not, click the File tab, click Options, and select the Add-Ins ...