Excel (Win) - 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 Micosoft Excel 2003 or under the Data tab in Excel 2007 and 2010.

If it is not listed, you will have to add it.

Excel 2007, 2010, and 2013

The menu path will depend on which version of Excel you are using:

  1. In Excel 2007, go to the Microsoft Office button -> Excel Options.

    Excel 2007 Options

  2. In Excel 2010 or 2013, go to File -> Options.

    Excel 2010 Options

  3. Select Add-Ins and 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.

    Excel 2003 Add-Ins Menu

  4. Place checkmarks next to Analysis ToolPak and Analysis ToolPak - VBA and click OK.

Excel 2003

  1. Go to Tools -> Add-Ins....

    Excel 2003 Tools Menu

  2. Place checkmarks next to Analysis ToolPak and Analysis ToolPak - VBA and 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.