Learn the simplest way to enable the Analysis ToolPak in Excel and use it to perform quick statistical analysis with just a few clicks.
Excel is one of the most powerful applications out there. You can use it for data entry, calculations, cleaning, reporting, dashboards, financial modeling, automation, and even project management. It can even run advanced statistical analysis with just a few clicks using the built-in Analysis ToolPak add-in. It saves a lot of time because Excel performs all the calculations automatically based on the selected data and outputs the results on a new sheet. The only thing is that this add-in is disabled by default, and you need to enable it manually. That is where this tutorial helps you.
In this quick and easy tutorial, I will show you how to get the Analysis ToolPak in Excel and use it. Let’s get started.
Before You Start
- The steps below are tested to work in Excel 2019, 2021, and 365.
Steps to Get Analysis ToolPak in Excel
- Open the Start menu by clicking the “Windows” icon on the taskbar.
- Search and open “Excel“.
- Click “Options” in the bottom left corner.
- Go to the “Add-ins” tab on the left panel.
- Select “Excel Add-ins” from the “Manage” dropdown, then click “Go“.
- Select the “Analysis ToolPak” checkbox.
- Click “OK“.
- With that, you’ve added Analysis ToolPak for Excel.
Detailed Steps (With Screenshots)
First thing, open Excel. You can do that by opening the Start menu (click the “Windows” icon on the taskbar), searching for “Excel”, and clicking the “Open” option. Once the Excel application opens, click the “Options” option in the bottom left corner.
The above action opens the “Excel Options” dialog. Here, go to the “Add-ins” tab on the left sidebar. On the right panel, select “Excel Add-ins” from the “Manage” dropdown at the bottom of the dialog box and click the “Go” button next to it.
In the “Add-ins” dialog, select the “Analysis ToolPak” checkbox, and then click the “OK” button to enable it.
That is it. With that, you’ve added the Analysis ToolPak to Excel. From now on, you can use it to perform statistical analysis.
Using Analysis ToolPak to Perform Statistical Analysis & Creating Charts
After enabling the Analysis ToolPak add-in, you can use the Data Analysis option in Excel to perform statistical tests and create charts. For this example, I’ll create a basic histogram using the Data Analysis tool. Here’s how to do it.
First, open the Excel workbook with the data for which you want to create a chart. Next, go to the “Data” tab at the top and then click the “Data Analysis” option in the “Analysis” section to the right.
Now, select the tool of your choice under the “Analysis Tools” section and then click “OK“. In my case, I want to create a basic histogram. So, I selected “Histogram”.
Now, select the “Input Range” field, and select the cells you want to use for the analysis. For example, I select cell A1 to A30 using the mouse pointer. Next, select the “Chart output” checkbox at the bottom and then click the “OK” button.
Note: If you don’t select the “Chat output” button, Excel will not generate a chart. It will only perform the tests and display the results.
As soon as you do that, Excel will perform the calculations and create a chart in a new sheet in the same workbook.
—
That is all. It is that simple to get the Analysis ToolPak in Excel and use it to calculate and generate charts. If you have any questions or need help, comment below. I’ll be happy to assist.
