How to add Data Analysis in Excel [Windows & MAC]

In this article, we will learn how to add Data Analysis in Excel on both Windows and MAC operating systems.

If you plan to use Excel for more complex statistical analysis such as t-test, z-test, correlation, or regression, the Data Analysis ToolPak will provide the appropriate statistical macros to focus more on interpreting results and less on meticulous Excel calculus.

The Data Analysis ToolPak is not automatically loaded to Microsoft Office 365 and other older versions but is available as Add-in and can be installed with just a few clicks within the Excel interface – as you will see in a moment.

How to add Data Analysis in Excel on Windows

First, we need to open Excel, navigate to the Data tab, and check if the Data Analysis section is present. If not, proceed with the following steps to install Data Analysis Toolpak in Excel.

Data analysis in Excel missing. Source: uedufy.com

1. On the top bar, click on File, then select Options.

Install Data Analysis Toolpak in Excel. Source: uedufy.com

2. Select Add-ins from the left navigation tab in the Excel Options window. On the View and manage Microsoft Office Add-ins window select Analysis ToolPak (which should be listed under Inactive Application Add-ins). Click the Go button.

Navigate to Options in Excel. Source: uedufy.com

3. In the Add-ins window, select the Analysis ToolPak checkbox and click OK.

Install Data Analysis Toolpak in Excel. Source: uedufy.com

4. Finally, navigate to the Data tab in Excel and check the newly added Analysis section. The Data Analysis tool should now be listed there.  

Open Data Analysis in Excel (PC). Source: uedufy.com

How to add Data Analysis in Excel on MAC

Like Microsoft Excel on a PC, installing the Data Analysis ToolPak Add-in in Excel on a Mac computer is straightforward.

1. Go to the Data tab in Excel and click on the Analysis Tools icon to open the Add-ins window.

Alternatively, you can access the Add-ins window by navigating to Tools in Excel’s top menu and selecting Excel Add-ins.

2. Select the Analysis ToolPak checkbox on the Add-ins window and click the OK button.

Data Analysis tool pack in Excel. Source: uedufy.com

3. The Data Analysis tool should now be available on the Excel Data tab.

Open Data Analysis in Excel (MAC). Source: uedufy.com

How To Remove Data Analysis in Excel

To remove Data Analysis ToolPak in Excel, simply navigate to the Add-ins window [on PC: File Options Add-ins Go; on MAC: Tools Add-ins], unselect the Analysis ToolPak checkbox, and click the OK button.

Leonard Cucos
Leonard Cucos

Leonard is a Ph.D. student in Data Science and holds an MBA and B.Sc. He has an impressive public speaking profile on education, engineering, and research. He loves to help students achieve their academic objectives and believes education is the key to building a better future for mankind.

Articles: 26