Make sure the Analysis ToolPak is installed (other versions of Excel will require slightly different instructions).

This is a Microsoft Office Excel add-in that adds custom commands or custom features to Microsoft Office.

a. Open a new spreadsheet, then click the “File” tab in the upper left corner.

b. Click “Options” at the bottom of the left sidebar.

c. Click “Add-Ins” on the left. Make sure it says Manage:

“Excel Add-ins.” Click “Go”.

d. In the “Add-Ins available” box, select the “Analysis ToolPak” check box, and then click “OK.” If you already have a check mark in “Analysis ToolPak,” then it is already installed. Do not uncheck it and click the red X in the upper right corner of the dialog box to cancel.

Otherwise, continue.

e. If you are prompted that the Analysis ToolPak is not currently installed on your computer, click “Yes” to install it. Once loaded, the Data Analysis command is available in the Analysis group on the Data tab.