Install and use the Analysis ToolPak

Before using an analysis tool, you must arrange the data you want to analyze in columns or rows on your worksheet. This is your input range.

If the Data Analysis command is not on the Tools menu, you need to install the Analysis ToolPak in Microsoft Excel.

To install the Analysis ToolPak

  1. On the Tools menu, click Add-Ins.

    If Analysis ToolPak is not listed in the Add-Ins dialog box, click Browse and locate the drive, folder name, and file name for the Analysis ToolPak add-in, Analys32.xll — usually located in the Microsoft Office\Office\Library\Analysis folder — or run the Setup program if it isn't installed.

  2. Select the Analysis ToolPak check box.