 In this video tutorial, we're going to show you how to use the Descriptives tool, which is part of Excel's data analysis tool pack. Oh, okay. File. There you go. File. Then we go to Options, then you go to Add-ins. See in 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, understanding 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. That was D2 to D13, that's your input data. Now, we go to the Analysis Tool Pack. Data? Data Analysis from the Analysis Tool Pack. Okay. 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 we'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 is in the column. It's going to go into a new worksheet. And make sure you check Summary Statistics. I'm going to make sure that's checked off. Otherwise, you won't get anything. You want the basic summary statistics, okay. You know, the confidence level we didn't learn so we ignored it for now, okay. And again, in the Output Options, you can decide where you want to put this. I wanted a new worksheet. I say, okay, and I'm going to expand this. You can read it. Okay. Now, notice 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 you didn't learn yet, but you're going to learn that 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. And this is nice. Yes, you got the median. The mode, it'll give you the mode. I wouldn't use it. It's not so reliable in Excel, but it says not Apple because it wasn't a 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. Other than the standard deviation, here's 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. And 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. Yeah, sometimes 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.