Data Analysis for Excel

The Data Analysis tool pack for Excel is not always available by default. If you don't have data analysis in your Excel, you should be able to access it in the Fordham computer labs or the library.

Alternatively, you can always add it to your Excel using the following instructions:

(i) Load the Analysis ToolPak in Excel for Mac

1. Click the Tools menu, and then click Excel Add-ins.

2. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

3. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

4. If you get a prompt that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

5. Quit and restart Excel.

6. Now the Data Analysis command is available on the Data tab.

(ii) Load the Analysis ToolPak in Excel for Windows

1. Click the File tab, click Options, and then click the Add-Ins category.

2. If you're using Excel 2007, click the Microsoft Office Button , and then click Excel Options

3. In the Manage box, select Excel Add-ins and then click Go.

4. If you're using Excel for Mac, in the file menu go to Tools > Excel Add-ins.

5. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.

6. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

7. If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.