Skip to content

How to enable the Data Analysis toolpak in Excel 2010

G15th February 2013

C2 Comments

TGeneral, Microsoft Office, software

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”

  • Written by Abebe Aseffa on 26 March 2020:

    Perfectly installed to my computer.

    Thank you very much.

  • Written by rachel on 4 June 2020:

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

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.