To use the Analysis ToolPak in Excel 2007 you need to load it first.
1. When you have Excel open, Click the Microsoft Office Button , and then click
Excel Options.
2. Click Add-Ins, and then in the Manage box at the bottom of the schreen, select Excel
Add-ins.
3. Click Go.
4. In the Add-Ins available box, select the Analysis ToolPak check box, and then click
OK.
1. Tip If Analysis ToolPak is not listed in the Add-Ins available box, click Browse
to locate it.
2. If you get prompted that the Analysis ToolPak is not currently installed on your
computer, click Yes to install it.
5. After you load the Analysis ToolPak, the Data Analysis command is available in the
Analysis group on the Data tab.