The Analysis ToolPak is a Microsoft Excel add-in that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to enable it first.
Click the File tab, and then click Options
Choose Add-Ins from the navigation bar on the left and in the Manage box, select Excel Add-ins. Click Go.
In the Add-Ins available dialog-box, select the Analysis ToolPak check box and click OK.
If Analysis ToolPak is not listed in the Add-Ins available dialog-box, click Browse to locate it.
If you receive a message that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.
Working with a Mac? We have instructions for Enabling Data Analysis ToolPak (MAC) to help you get started!