Excel (Windows) - Data Analysis Pack
This document describes how to add the Data Analysis Pack to Microsoft Excel 2003, 2007, 2010, and 2013.
The Data Analysis pack is a powerful set of tools used to figure out the variance, correlation and covariance of data as well as other features. Although the Data Analysis pack is a standard feature that comes with Excel, it may not be loaded into Excel. If it is already added, Data Analysis will be listed under the Tools menu in Microsoft Excel 2003 or under the Data tab in Excel 2007 and 2010.
If it is not listed, you will have to add it.
Excel 2003
- In Microsoft Excel, open the Tools menu.
- Select Add-Ins....
- Toggle the checkboxes for Analysis ToolPak and Analysis ToolPak - VBA.
- Then click OK.
Excel should install the Data Analysis options from there. It may, however, require the original Microsoft Excel or Office CD to complete installation.
Excel 2007
- In Microsoft Excel, click on the Microsoft Office button to open the drop-down menu.
- Select Excel Options.
- Click on the Add-Ins tab in the left-hand side menu.
- Confirm that the Analysis ToolPak appears in the list of Inactive Application Add-ins.
- If it is inactive, click on Go... next to the Manage: Excel Add-ins drop-down menu.
- Toggle the checkboxes of Analysis ToolPak and Analysis ToolPak - VBA.
- Click OK.
Excel 2010 and 2013
The menu path will depend on which version of Excel you are using:
- In Microsoft Excel, open the File drop-down menu.
- Select Options toward the bottom of the menu.
- Click on the Add-Ins tab in the left-hand side menu.
- Confirm that the Analysis ToolPak appears in the list of Inactive Application Add-ins.
- If it is inactive, click on Go... next to the Manage: Excel Add-ins drop-down menu.
- Toggle the checkboxes of Analysis ToolPak and Analysis ToolPak - VBA.
- Click OK.