How to Add Data Analysis in Excel?

Adding Data Analysis in MS

When Excel is built from the ground up to make bring data analysis in a way approachable to the larger masses, there are still some features that are not readily available. One such feature is the Data Analysis Toolpak which contains a wide range of statistical operations that can be exercised over the data.

Also read: Tips to Use Excel’s Filter Tool for Faster Data Analysis

Though there are umpteen formulae inbuilt within MS Excel that can be summoned right after the equals (=) sign, there is more to statistics than that. Determining a sum or a product of the given data ain’t the same as that of calculating the Analysis of Variance (ANOVA) in a given dataset.

It would be a herculean task to put together each piece of information deduced from the given data using a formula & calculate the required statistic if it wasn’t for the Data Analysis Toolpak! Such a blessing to have this feature embedded in MS Excel.

Those within the Data Analysis Toolpak will take us through each step & make it easier to deduce a statistic rather than running around with formulae.

Listed below are some of the things that can be found within the Data Analysis Toolpak.

Locating the Data Analysis Toolpak

You may wonder where is this feature located within MS Excel. But here’s the catch, it shall be included within the Data tab only if we ask MS Excel to do so.

Location of Data Analysis Toolpak
Location of Data Analysis Toolpak

So how shall we ask MS Excel to do that? The following article shall elaborate on the sequence of steps required.

Adding the Data Analysis Toolpak

One shall get started by clicking on the File menu in the top left corner of the Tabs section as indicated below.

Selecting File Menu
Selecting File Menu

Now one shall be taken to a list of options within the File menu where one needs to choose the Options as indicated below.

Selecting Options from File Menu
Selecting Options from File Menu

Once done, a dialog box titled Excel Options appears. Now one ought to select the Add-ins option as shown below.

Selecting Add ins within Excel Options Dialog
Selecting Add-ins within Excel Options Dialog Box

Now one shall get into the add-ins manager which displays the list of add-ins that are both active & inactive. Search for the Data Analysis Toolpak in the inactive region & click on it as shown below.

Choosing the Data Analysis Toolpak Add in
Choosing the Data Analysis Toolpak Add-in

Now the Add-ins pop-up shall appear prompting you to choose the required items from the Data Analysis Toolpak. One ought to tick all the items needed & then click on OK in the same sequence as indicated below.

Selecting Items within Data Analysis Toolpak
Selecting Items within Data Analysis Toolpak

Once done MS Excel buffers for some time wherein it searches and loads all the necessary scripts in the back-end & then the screen shall appear with a new section titled Analysis within the Data tab loaded with the options from the Data Analysis Toolpak as shown below.

Data Analysis Toolpak is loaded
Data Analysis Toolpak is loaded!

Clicking on the icon of Data Analysis shown in the above image shall make the Data Analysis dialog box with all the features listed at the beginning of this article appear.

Data Analysis Dialog
Data Analysis Dialog Box

One can now choose the required tool within this dialog box to carry out the specific statistical analysis on the dataset in hand.


There are numerous equally interesting & informative articles in QuickExcel that serve to be a great help to those who pursue their journey to excel in MS Excel. Hope this article helped you understand how to add Data Analysis Toolpak in MS Excel & has given you what you came looking for! To know more about how to use a formula in MS Excel, have a look at this article. Until then, Ciao!