Stat Trek

Teach yourself statistics

Stat Trek

Teach yourself statistics

How to Install the Data Analysis ToolPak in Excel

To access advanced analytical functions in Excel, you need a free Microsoft add-in called the Analysis ToolPak, which may or may not be already installed on your copy of Excel.

To determine whether you have the Analysis ToolPak, click the Data tab in the main Excel menu. If you see Data Analysis in the Analysis section, you're good. You have the ToolPak.

Excel data tab
Excel data tab

If you don't have the ToolPak, here's how to get it:

  • Click the File tab in the main menu.
  • In the list of menu items under the File tab, click the Options item to display the Excel Options dialog box.
    Excel options
  • On the Excel Options dialog box, click the Add-Ins menu item to manage Microsoft add-ins.
    Excel add-ins menu item
  • From the Manage dropdown list, select Excel Add-ins and click Go to display the Add-Ins dialog box. (If you have Excel for Mac, go to Tools > Excel Add-Ins in the File menu.)
  • In the Add-Ins box, select Analysis ToolPak; and click OK.
    Analysis ToolPak in Excel add-ins box
    If the ToolPak is not listed in the Add-Ins available box, click Browse to find it. If you are prompted that the ToolPak is not installed on your computer, click Yes to install it.

With that, the Data Analysis item will appear in the Analyze section of the main menu Data tab, signifying that the ToolPak was installed.