Statistics How To

Excel Data Analysis ToolPak: Easy Steps and Video

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 microsoft excel data analysis toolpak

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!
Excel Data Analysis ToolPak: Easy Steps and Video was last modified: October 15th, 2017 by Andale

9 thoughts on “Excel Data Analysis ToolPak: Easy Steps and Video

  1. Scott Wycoff

    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

  2. Andale Post author

    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.

  3. Adebisi Adeyinka Ridwan

    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

  4. Andale Post author

    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 :).

  5. Jackson

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