How to Install Data Analysis in Excel

Microsoft Excel is used for different sorts of data analysis very widely. If we want to develop a complex statistical or engineering analysis, it will take time and labor. But we can eradicate the problems by using the Data Analysis option in Excel. But we can’t use the function naturally. We have to install it first. In this article, we will show the way to install data analysis in Excel.

What Is Data Analysis Toolpak?

Data Analysis Toolpak is an Add-Ins in Excel which is essential to enable Data Analysis. So by installing Data Analysis Toolpak we can use the Data Analysis option which is very helpful in solving complicated problems.

Use of Data Analysis in Excel

We can do various complex calculations by using Data Analysis in Excel. We can easily find Histogram, Correlation, Covariance, Exponential Smoothing, and a lot more with the help of Data Analysis.

Steps to Install Data Analysis in Excel

Step 1: We have to open one Excel sheet first. Then we need to select the File tab from the ribbon.

Step 2: After opening the File tab, we need to select Options from the list.

Step 3: We will see an Excel Options window pop up. We have to select Add-Ins from the list.

Step 4: We will see the list come up. We need to select Analysis Toolpak and then press Go.

Step 5: We will see an Add-Ins window. We need to select Analysis Toolpak then OK.

You will get the Data Analysis option.

Hurrah! We have installed Data Analysis.

Read More: How to Use Analyze Data in Excel

Verifying If Data Analysis Is Installed Correctly

Step 1: We have to go to the Data tab in the ribbon and then select Data Analysis from the ribbon.

Step 2: We will see a Data Analysis window where different Analysis Tools are present.

Now we are sure about the installation of Data Analysis.

How to Install Data Analysis in macOS

The steps to install Data Analysis Toolpak in macOS are slightly different from those in Windows. We will show the steps to install Data Analysis Toolpak in macOS.

Step 1: First we need to select the Tools menu and then click Add-Ins.

Step 2: Add-Ins available box will appear. We need to select Analysis Toolpak from the list and click OK.

Step 3: If the Add-Ins available box doesn’t appear, we need to click browse to locate it.

Step 4: If we get a prompt that the Analysis Toolpak is not present on your device, we have to click on the option Yes to install the Analysis Toolpak.

Step 5: Now we have to exit and restart (reopen) Excel and we will see the Data Analysis command in the Data tab.