How To Add Data Analysis in Excel 2022

By Wendy Tietz, CPA, Ph.D.; Jennifer Cainas, CPA, DBA; and Tracie Miller-Nobles, CPA

Are you interested in running more advanced data analysis in Excel? If so, you can add the Analysis ToolPak to your current version of Excel. It provides several analysis functions including Anova, Correlation, Descriptive Statistics, Histogram, Regression, and T-tests.

How to add the Analysis ToolPak

After opening Excel, click File.

At the bottom of the File menu, click Options.

Click Add-Ins and then Go… .

This opens an additional pop-up window that allows you to select the Analysis ToolPak. After selecting the add-in, click OK.

After you have added the Analysis ToolPak to your Excel software, you will find it on the Data tab. Click on Data and then Data Analysis.

You can now complete a number of advanced data analysis tasks using Excel. Keep an eye out for our next article, which will demonstrate how to use the descriptive statistics tool in the Analysis ToolPak.

— Wendy Tietz, CPA, CGMA, Ph.D., is a professor of accounting at Kent State University in Kent. Ohio; Jennifer Cainas, CPA, DBA, is an instructor of accountancy at the University of South Florida in Tampa; and Tracie Miller-Nobles, CPA, is an associate professor of accounting at Austin Community College in Austin, Texas. See their site AccountingIsAnalytics.com for resources they have developed for teaching data analytics in introductory accounting. To comment on this article or to suggest an idea for another article, contact JofA senior editor Courtney Vien at .

The Data Analysis function is extremely useful in Microsoft Excel. However, you might notice that you don’t have access to this function. For example, you can’t see Data Analysis in Excel, Data Analysis is greyed out, or Data Analysis is missing. Don’t worry, there’s a solution to this issue.

Save time by using the Analysis ToolPak for complex statistical or engineering analysis. All you have to do is provide the data and parameters for each analysis. The tool uses these to calculate and display the results in an output table, or in some cases, appropriate charts.

This article teaches you how to fix, enable, and use the Data Analysis ToolPak in Excel. Do you have any additional questions? Check our Help Center, or get quick live assistance by contacting our experts.

How to load and enable the Data Analysis ToolPak?

First, before you’re able to run Data Analysis on your worksheets, you need to enable the ToolPak from your settings. This process is different depending on your platform. Proceed to the appropriate guide and follow the steps to enable the ToolPak.

Load the Data Analysis ToolPak in Excel (Windows)

For our guide, we’ll be using the latest Excel 2019 release. The steps may vary from your software, depending on your version. Don’t hesitate to contact us if you need any further help.

1. Open Microsoft Excel. You should be redirected to the default Home screen. Here, click on Options found in the left-side pane.
   
   
   
   
2. If you can’t see this button right away, your Excel window may be too small to display all menu options. In this case, click on More… and then select Options.
   
   
   
   
3. Use the left-side pane and switch to the Add-ins tab. You should see a number of available add-ins for your Excel version.
   
   
   
   
4. Select Excel Add-ins from the Manage drop-down menu, and then click on the Go… button.
   
   
   
   
5. A new pop-up window should appear. Here, make sure to place a checkmark next to the Analysis ToolPak. When done, click on the OK button.
   
   
   
   
6. Done! You now have the Data Analysis ToolPak enabled in Excel 2019 for Windows.

Load the Data Analysis ToolPak in Excel (macOS)

For our guide, we’ll be using the latest Excel 2019 for Mac release. The steps may vary from your software, depending on your version. Don’t hesitate to contact us if you need any further help.

Note: The Data Analysis ToolPak is not available in Excel 2011 for Mac. If you can’t find the ToolPak, chances are that you’re currently running this version.

1. Open Excel for Mac. In order to access the add-ins, you need to open an existing workbook or create a new one.
   
   
   
   
2. Use the header interface and click on Tools. Select Excel Add-ins from the dropdown menu.
   
   
   
   
3. A pop-up window should appear. Here, ensure that you place a checkmark next to Analysis ToolPak. When done, click the OK button.
4. Done! You successfully enabled the Data Analysis ToolPak in Excel for Mac.

How to use the Data Analysis ToolPak?

After enabling the ToolPak for professional and complex data analysis, you can begin using it. The instructions below work on all versions of Excel that currently support this add-in.

1. Open a workbook, or create a new one. Ensure that your workbook has data in it before you use the analysis tools.
2. Switch to the Data tab in your ribbon interface. This should be located between Formulas and Review.
   
3. Click on Data Analysis in the Analysis section. If you can’t see this button, you need to enable the Analysis ToolPak first.
   
   
   
   
4. Select the analysis tool you want to use. When done, click the OK button to start up the tool.
   
   
   
   
5. Follow the chosen tool instructions to analyze your data on a professional level.

Final thoughts

If you need any further help with Excel, don’t hesitate to reach out to our customer service team, available 24/7 to assist you. Return to us for more informative articles all related to productivity and modern-day technology!

Would you like to receive promotions, deals, and discounts to get our products for the best price? Don’t forget to subscribe to our newsletter by entering your email address below! Receive the latest technology news in your inbox and be the first to read our tips to become more productive.

You may also like

» What Version of Excel Do I Have?
» How To Print Gridlines in Excel
» How to Reference Another Sheet in Excel