Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

How to enable the Data Analysis toolpak in Excel 2010

Instructions for adding the Data Analysis tool pack to Microsoft Excel

Microsoft Office’s Excel package contains a number of data-analysis tools for professionals who require an ability to perform sophisticated mathematical analyses of data.

This feature is not enabled by default. Here are instructions for enabling Data Analysis in Excel 2010.

Step 1

In the menu, go to File > Options and then click on “Add Ins” on the left-hand menu.

Excel-AddIns-1

Step 2

In the “Manage” drop-down box at the bottom, select “Excel Add-ins” and press “Go…

A dialogue box will appear. Choose “Analysis ToolPak” and “Analysis ToolPak – VBA

Excel-AddIns-2

If Analysis ToolPak is not listed, click “Browse” to locate it. If a prompt says that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

Step 3

Click “OK” and the selected data packs will be installed. You will be returned to the spreadsheet that you were working on.

Now when the “Data” manu item is selected, there should be an option called “Data Analysis” on the far-right-hand side of the ribbon.

Excel-AddIns-3

Statistical analysis is now possible in Excel.

   

Comments

2 responses to “How to enable the Data Analysis toolpak in Excel 2010”

On 26 March 2020, Abebe Aseffa wrote: Hyperlink chain icon

Perfectly installed to my computer.

Thank you very much.

Reply

On 4 June 2020, rachel wrote: Hyperlink chain icon

i made the process to add data analysis and it not appeer
what can be?

Reply

Have Your Say

The following HTML is permitted:
<a href="" title=""> <b> <blockquote cite=""> <code> <em> <i> <q cite=""> <strike> <strong>

Comments will be published subject to the Editorial Policy.