how to install data analysis in excel mac

She created the pictures for this guide and provided an overview of the instructions.

Now, let’s see if it worked! Click on the “Data” tab at the top:ĭo you see a “Data Analysis” button? If so, great! You can now perform statistics in Excel! If not, look back through the prior steps and see where you went wrong.Ī very special thanks goes to my former MBA student, Misty Bussie. Do you see a sub-tab labeled “Analysis” or “Data Analysis”? If not, then perform the following steps:Īs seen below, click on the “Tools” menu:Ĭlick the checkbox beside “Analysis Toolpak”: To determine whether your Data Analysis tab is activated, open a blank Excel workbook. For some reason, Excel defaults the Data Analysis tab as inactive, although it is completely free and pre-installed. To remove Data Analysis ToolPak in Excel, simply navigate to the Add-ins window, unselect the Analysis ToolPak checkbox, and click the OK button.Have you ever wanted to calculate a simple statistic in Excel, but couldn’t find the correct tab to do so? If so, it is possible that you did not have the “Data Analysis” tab activated. The Data Analysis tool should now be available on the Excel Data tab. Select the Analysis ToolPak checkbox on the Add-ins window and click the OK button.ģ. Go to the Data tab in Excel and click on the Analysis Tools icon to open the Add-ins window.Īlternatively, you can access the Add-ins window by navigating to Tools in Excel’s top menu and selecting Excel Add-ins.Ģ. Like Microsoft Excel on a PC, installing the Data Analysis ToolPak Add-in in Excel on a Mac computer is straightforward.ġ. The Data Analysis tool should now be listed there. Finally, navigate to the Data tab in Excel and check the newly added Analysis section. In the Add-ins window, select the Analysis ToolPak checkbox and click OK.Ĥ. On the View and manage Microsoft Office Add-ins window select Analysis ToolPak (which should be listed under Inactive Application Add-ins). Select Add-ins from the left navigation tab in the Excel Options window. On the top bar, click on File, then select Options.Ģ. If not, proceed with the following steps to install Data Analysis Toolpak in Excel.ġ. How to add Data Analysis in Excel on Windowsįirst, we need to open Excel, navigate to the Data tab, and check if the Data Analysis section is present. 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.

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. In this article, we will learn how to add Data Analysis in Excel on both Windows and MAC operating systems.

How to install data analysis in excel mac