 In this video tutorial, we're going to show you how to use the descriptive tool which is part of Excel's data analysis tool pack. Okay, first you're going to have to add in analysis tool pack. This is called an add-in. Watch what I do. You go to file, go to options. You're in, sorry, let's get back to Excel. Okay, file. There you go. File, then we go to options. Then you go to add-ins. You see on the bottom it says manage Excel add-ins, go and check analysis tool pack. Let's check it and say okay. And now we're going to be using these tools, the very valuable tools for analysis. Okay, if you did it right, when you go to data, you'll see data analysis. If it's not checked, you won't see this tool called data analysis. Again, you have to check off analysis tool pack to have that. Okay, now we're going to show you a quick way to get descriptive statistics. Now it won't give you the median, actually it might give you the median, it won't give you the quartiles, it won't give you percentiles, but it'll definitely give you very important statistics and very quickly. You will get the mean and the standard deviation, a whole bunch of other things. So let's see how to do this. Again, keep in mind where the data is located. You have to always remember that. And that was D2 to D13, that's your input data. And now we go to the analysis tool pack. Data? Data analysis from the analysis tool pack. Okay, and now you look for descriptive statistics. It's called descriptive statistics. Notice the other things here that we're going to learn. You have a correlation, the other things here that we're going to use. You're going to need this tool pack. Very useful. So go to descriptive statistics. Okay. And now again, I need to show the computer where the input range is. So you'll grab it for me. Grab it. And did it come out right? Yes. And notice that this is a default group by columns. So really group by columns in the column is going to go into a new worksheet. And make sure you check summary statistics. Make sure that's checked off. Unless you won't get anything. You want the basic summary statistics. Okay. You know, the confidence level we didn't learn in order for now. Okay. Again, in the output options, you can decide where you want to put this. I wanted a new worksheet. I say, okay, I'm going to expand this. You can read it. Okay. Now it is what you have. You've got the mean. We did this the hard way one by one. You got the mean 73.5. You got the standard error, which I didn't, you didn't learn yet, but you're not in the second half of the course. Basically, you get a lot of good stuff that you would have had to do one at a time before using the formula. This is nice. Yes, you got the median. The mode it'll give you them over there. I wouldn't use it. It's not so reliable in Excel, but it says not apple because it wasn't the mode, because no value showed up more than once. All right, so we have a standard deviation same as before, the variance, which is the standard deviation squared. The standard deviation here is a sample standard deviation. Cretosis, which your teacher may or may not teach you skewness. You're going to learn about that is. And then you have the range of the data. You also can see the range. The highest score on that test was 100. The data, the lowest is a 44. So the range is 56. You also have the sum. And of course you have the count. Always check the count to make sure it corresponds. Make sure you got all the numbers. Some of these people are not careful. We have all 12 numbers. See, right away in one shot, I got some of the very basic statistical measures that you need. Okay, good luck.