How to Add Data Analysis in Excel (with Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

Data Analysis is an Excel add-in program that helps us perform complex statistical and financial analyses. It has made several mathematical operations easy such as Correlation, Fourier Analysis, Moving Average, Regression, etc. By default, the Data Analysis Toolpak is not installed. Once you install the plug-in you will find it in the Data tab. In this article, I will show you how to add the Data Analysis Toolpak in Excel. So, without having any further discussion, let’s get started.

Basics of Data Analysis Toolpak

The Data Analysis ToolPak is an Excel add-in that provides data analysis tools for statistical and financial analysis. It has resources for matrix operations, regression analysis, and descriptive statistics.

The Data Analysis ToolPak must first be activated before it can be used. Open Excel and select the Data tab to get started. You can use the toolpak to examine data in Excel once it has been installed. Select the data you want to analyze, then click the Data Analysis button to utilize the toolpak.

Steps to Add Data Analysis Toolpak in Excel

The Data Analysis Toolpak is an add-in program. You need to activate it first before starting working with it. Now follow the steps below to add the Data Analysis Toolpak in Excel.

Step-1: Opening Excel Options Dialog box

At first, you have to open the Excel Options dialog box. There you will all the necessary options to add the Data Analysis Toolpak. To open the Excel Options dialog box,

  • Go to the File menu from the main ribbon.

Steps to Add Data Analysis Toolpak in Excel

  • After that, click on Options.

Now the Excel Options dialog box will appear in front of you.

  • Click on the Add-ins menu in the Excel Options dialog box.
  • Now click on the drop-down icon beside Manage.

In the drop-down menu, you will see 5 options which are:

  • Excel Add-ins
  • COM Add-ins
  • Actions
  • XML Expansion Packs
  • Disabled Items

Each of them contains a different set of options, you may need to use others for another toolpak, for adding Data Analysis Just select the Excel Add-ins option.

Steps to Add Data Analysis Toolpak in Excel

Read More: [Fixed:] Data Analysis Not Showing in Excel (2 Effective Solutions)

Similar Readings

Step-2: Opening Add-ins Dialog Box

After selecting the Excel Add-ins options from the drop-down list, click on the Go command.

Steps to Add Data Analysis Toolpak in Excel

This time the Add-ins dialog box will appear.

  • Select Analysis Toolpak
  • Then click on the OK

You can also select the Analysis Toolpak – VBA option. This will enable you to work with Visual Basic code to analyze data.

Steps to Add Data Analysis Toolpak in Excel

So the Data Analysis Toolpak has been added to the main ribbon.

To open the Data Analysis Toolpak,

  • Go to the Data
  • From the Analysis group, you will see the Data Analysis command, click to explore that.

Read More: How to Analyze Sales Data in Excel (10 Easy Ways)

Exploring Features of Data Analysis Toolpak

As you click on the Data Analysis command, the Data Analysis dialog box appears.

Now you will have access to perform various statistical and mathematical operations. Some of them are,

  • Correlation
  • Regression
  • Covariance
  • Descriptive Statistics
  • Fourier Analysis
  • Histogram
  • Moving Average

Correlation, Regression are frequently used tools to determine the correlation coefficient, find the correlation, calculate the P-value, perform linear regression, forecast sales, and many more. You’ll find that the Data Analysis toolpak eases the calculation. Explore the options to get to know them, you may need them from time to time while performing any analytical task.

Things to Remember

  • Once you’ve added the Data Analysis Toolpak you’ll find that every time you open the Excel application within the Data tab.
  • The Data Analysis Toolpak can work on a single worksheet at a time.
  • When Data Analysis Toolpak works on a group of sheets, the result appears in the first worksheet.
  • On the rest of the sheets, the bare formatted tables appear.
  • To apply the Data Analysis Toolpak on a group of sheets, you must apply it on each sheet separately.
  • The Data Analysis Toolpak is available on Excel 2007 and later versions. So, if you are using an earlier version, then you may need to update your Excel to add the Data Analysis
  • Before using the Data Analysis Toolpak, you must install it first.


To sum up, we have discussed how to add data analysis in Excel. Please don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.

Related Articles

Mrinmoy Roy

Mrinmoy Roy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF