Excel for statistics > How to Load the Microsoft Excel Data Analysis ToolPak
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.
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!