Working with the Data Analysis ToolPak

John Wiley & Sons
A free video tutorial from John Wiley & Sons
Video Training
4.4 instructor rating • 31 courses • 44,832 students

Lecture description

In this video you will learn how to use the Data Analysis ToolPak.

Learn more from the full course

Statistical Analysis Excel 2013 Essentials

Learn the ins and outs of statistical analysis with Excel 2013

04:06:40 of on-demand video • Updated November 2014

  • Learn how to locate the built-in functions, how to set-up a shortcut to the functions and how to load the Data Analysis ToolPak.
  • Learn how to group data into intervals with a built in function and the data analysis tool, sort tables and summarize your data by counting your data points.
  • Explore the three common types of charts featured in excel: column, line, and pie and scatter.
  • Discover how to use Sparklines and PowerView in Excel.
  • Learn how to calculate the statistics of central tendency, also known as, the average, median, mode in Excel. Find the mean and standard deviation together.
  • Apply normal distributions and understand the concept of sampling distributions.
  • Discover the connection between hypotheses and sampling distribution in excel and learn how to test hypothesis about variances.
  • Create and interpret statistics in a business or classroom setting.
English [Auto] This video shows you how to use Excel data analysis tool pack the tool pack includes a lot of tools that you'd find in a software package dedicated to statistics but they come free and excel as an add in you just have to add the men in an earlier video I showed you how to do just that. I'll use one of the tools to calculate descriptive statistics of the scores you see here in column H. There is a button to get to the tool pack lives on the Data tab. So I click that tab and we'll get started after you add in the tool pack. This button goes into the analysis area. I click it to open up the set of data analysis tools as you can see this opens up the data analysis dialog box. Here the analysis tools box also like descriptive statistics and click OK. And that opens up the descriptive statistics dialog box every tool in the tool pack has its own dialog box and each one is different depending on what the tool does. The first thing we have to do is let the tool know where the data are that goes into the input range box which is active. This is the dialog box opens. So our click H-1 hold down the Shift key and click. Age 10 knows that Excel has added dollar signs to the cell identifiers. This happens with the tools in the tool bag as you can see Excel assumes the data are grouped by columns. If the scores are in rows you have to click the rows radio button. It's important to let Excel know that the first cell in the range is the label. So I'll check the checkbox next to labels in the first row. It's a good idea to go with the default option. New worksheet plie mistake. It's a good idea to go with the default output option new worksheet plie. This means that the results will appear in a new tab. You also have to check at least one of the remaining boxes. I'll check some statistics to see the results. Click OK this opens the tab with the results. The descriptive statistics in order to see everything clearly you have to expand column A. And this happens quite a bit with the tool packs. Now I can see the statistics. This tool calculates for you. Notice that the label on so H-1 is the header. So for clarity in the results it's a good idea to include the first row label as the input range. The tool gives you everything from mean to standard deviation to kurtosis. Sounds like a diseased one to maximum minimum and more so that's a look at using the tool in the data analysis tool pack.