Excel How To: Data Analysis ToolPak Installation

by

Excel’s Data Analysis Tool, called Data Analysis ToolPak, has most of the functions that an introductory-statistics class would require: Frequency Table, Histogram, t-test, ANOVA, and so on.

How To Install Excel Analysis ToolPak

0. Preview of the Outcome

  • Here’s the image showing what’s going to happen when you successfully install the Data Analysis ToolPak for PC users: “Data Analysis” menu will be shown at the right end of the menu bar when you click the Data menu.
  • If you are a Mac user, it would look like this:

Step-By-Step Instructions for PC Users

  1. Open Excel – Click ‘File’ – Click ‘Options’

2. Select ‘Add-Ins’ from the left menu bar

3. (At the bottom) ‘Manage: Excel Add-ins’ – Click Go (Do not click OK, yet)’

4. Check ‘Analysis ToolPak’ – Click ‘OK’

Here are the instructions again with images

1. Open Excel – Click ‘Fle’ – Click ‘Options’

2. Select ‘Add-Ins’ from the left menu bar

3. (At the bottom) ‘Manage: Excel Add-ins’ – Click Go (Do not click OK, yet)’

4. Check ‘Analysis ToolPak’ – Click ‘OK’

5. Successful Installation

Now, you should be able to see the ‘Data Analysis’ menu at the right end of the menu bar when you click ‘Data’ Tab

Here’s a short video showing the installation process of Excel Analysis ToolPak

Step-By-Step Instructions for Mac Users

  1. Open Excel – Click [Tools] menu – Choose – Excel Add-ins…
  2. Check Analysis ToolPak (the first availabile Add-in)
  3. Click OK

Leave a Comment