Excel for statistics > How to Load the Microsoft Excel Data Analysis ToolPak

**Contents:**

Load the Excel Data Analysis Toolpak in Excel 2013

Load the Excel Data Analysis Toolpak in Excel 2007-2010

## How to Load the Data Analysis Toolpak in Excel 2013

Watch the video or read the steps below:

The Data Analysis Toolpak is included with every copy of Excel. It gives you access to a wide variety of statistical functions including histograms, correlation, a range of z-test and t-test functions and a random number generator. Once you load the Data Analysis Toolpak you can access it by clicking “Data Analysis” in the “Data” tab.

Step 1: **Click the “File” tab and then click “Options.”** The Options window will open.

Step 2: **Click “Add-Ins.”** Add-Ins is listed at the bottom of the left-hand column,

Step 3: **Click the “Go” button, next to Manage Excel Add-Ins.** Manage Excel Add-Ins is at the very bottom of the pop up window, underneath the list of Add-In options.

Step 4:

**Check the “Data Analysis Toolpak” check box.**

Step 5: Click “OK.” The Data Analysis Toolpak is now loaded into Excel.

Step 6:

**Click the “Data” tab and then click “Data Analysis”**— located at the far right of the Toolbar in the Analysis group — to access the Toolpak.

## How to Load the Microsoft Excel Data Analysis ToolPak: Excel 2007-2010

The Data Analysis ToolPak is added from the Office menu.

Step 1: **Click the “Office” button **at the top left (with the Microsoft logo) and then click “Excel Options.”

Step 2: **Click “Add-Ins,”** then select “Excel Add-Ins” in the Manage box.

Step 3: **Click “Go,”** then click the “Analysis ToolPak” check box.

Step 4: **Click “OK.”** The Data Analysis ToolPak is now ready for use in the “Data” tab.

**Note**: Excel has been known to be “buggy” with stats calculations, especially things like f-tests. These bugs are thought to be fixed with Excel 2013. So if you’re going to use Excel for stats, make sure you know the limitations of the ToolPak. Want more information? See this article on using Excel for Statistics.

Check out our YouTube channel for more Excel/stats help and tips!

If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.

Comments are now closed for this post. Need help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!
thank you so much …..you save my life.It is really helpful

Hi !

Thank you so much! You’ve been the most useful link about excel and Stat I have found so far!

thank you so much

Hello –

I followed your instructions for the download to Excel 2013. The “analysis” portion of Data did not show up. The last item on the right was “outline.”

Many thanks for your help.

Scott

Solution that worked for this person: Uncheck Analysis ToolPak, exit and then go back in and re-check the box. It now should appear under the data tab.

HELLO,

Just like i said; that i would get back when i’m stuck. I really found your works useful and valuable, Great thanks for that.

but i actually got stuck during practice, i would be very happy if you could put me through.

IN AN EXPERIMENT TO CHECK WHICH VARIETIES OF SORGHUM HAVE MORE SUGAR CONTENT AND WHICH VARIABLES ARE RESPONSIBLE FOR THAT.

THE FOLLOWING DATA WAS TAKEN;

Designation EST SV 50%FL SGy HPL Brix

A1 34 5 65 3 0 12

A3 17 5 80 0 199 15

SVI44 32 5 82 0 243 11

BSCV64 27 4 0 4 164 7

WILLIAMS 36 5 78 2 206 15

235SI 33 5 65 4 221 10

5-1SS10-31 33 5 65 4 266 10

A35 27 5 65 3 216 16

Designation = THIS IS THE NAME/VARIETY OF SORGHUM PLANTED

EST = ESTABLISHMENT COUNT

SV = SEEDLING VIGOUR

50%FL = DAYS TAKEN BEFORE 50 PERCENT OF PLOT STARTS TO FLOWER

SGy = SCALE OF 1-5 DESCRIBING HOW GREEN IS THE PLANT AT THE TIME OF 50%FL

HPL = PLANT HEIGHT

Brix = SUGAR CONTENT OF THE PLANT

1) PLS WHAT KIND OF ANALYSIS AM I TO USE IN THIS CASE, (ONE-WAY OR TWO-WAY ANOVA)

2) WHICH ONE DO I TAKE AS THE FACTOR AND WHICH IS THE TREATMENT.

THANK YOU VERY MUCH AS I ANXIOUSLY AWAIT YOUR GUIDING REPLY.

I

I would guess it’s a one-way anova (test the hypothesis that the mean values of the measurement variable are the same in different groups). But you know what you are doing with your data better than I do. If you’re classifying groups two ways, then use two-way.

As for factor and treatment, are you performing factor analysis, or ANOVA?? You may want to read What is Factor Analysis?. It *sounds* like your treatment variables would be the sugar content, plant height etc. But (like I said above) — you know what you’re doing with your experiment more than I :).

I have followed all the steps for loading the Analysis toolpak but it does not show up. What could be the problem?

Try unchecking and rechecking the toolpak box.