WEBVTT 00:00:00.000 --> 00:00:03.437 align:middle line:90% [MUSIC PLAYING] 00:00:03.437 --> 00:00:16.094 align:middle line:90% 00:00:16.094 --> 00:00:17.760 align:middle line:84% In this short video, we're going to talk 00:00:17.760 --> 00:00:20.700 align:middle line:84% about how you can run descriptive statistics using 00:00:20.700 --> 00:00:21.870 align:middle line:90% Excel. 00:00:21.870 --> 00:00:23.610 align:middle line:84% So the first thing that we're going to do 00:00:23.610 --> 00:00:25.950 align:middle line:84% is we're going to pick this variable right here-- 00:00:25.950 --> 00:00:29.920 align:middle line:84% the big CA, or the communication apprehension total. 00:00:29.920 --> 00:00:33.090 align:middle line:84% So this is where we took all 24 items of the personal report 00:00:33.090 --> 00:00:36.420 align:middle line:84% of communication apprehension 24 and added them together and got 00:00:36.420 --> 00:00:38.310 align:middle line:90% these numbers. 00:00:38.310 --> 00:00:42.120 align:middle line:84% So, how we're going to do this is we're going to come up here 00:00:42.120 --> 00:00:44.805 align:middle line:84% and we're going to go to Tools, Summary Statistics. 00:00:44.805 --> 00:00:47.490 align:middle line:84% So we're going to click on Summary Statistics. 00:00:47.490 --> 00:00:50.140 align:middle line:84% And then what we want to do is find this data variable. 00:00:50.140 --> 00:00:52.840 align:middle line:84% So I'm going to go ahead and find Big CA. 00:00:52.840 --> 00:00:55.815 align:middle line:84% Now you'll notice that it has a bunch of possibilities in here. 00:00:55.815 --> 00:00:57.440 align:middle line:84% It has what's called the extreme, which 00:00:57.440 --> 00:01:00.150 align:middle line:84% is a count, a sum total, minimum, maximum, 00:01:00.150 --> 00:01:02.910 align:middle line:84% the location, your mean, your median, and your mode, 00:01:02.910 --> 00:01:03.780 align:middle line:90% your higher moments. 00:01:03.780 --> 00:01:05.735 align:middle line:84% It has your skewness and your Kurtosis. 00:01:05.735 --> 00:01:08.850 align:middle line:84% It has your range, standard deviation, and variance, 00:01:08.850 --> 00:01:11.490 align:middle line:84% and some other ones if you wanted to run them. 00:01:11.490 --> 00:01:13.380 align:middle line:84% So there's a bunch of different tests. 00:01:13.380 --> 00:01:17.490 align:middle line:84% For our purposes, I'm going to get rid of that variance one. 00:01:17.490 --> 00:01:19.050 align:middle line:84% I'm going to get rid of the sum total 00:01:19.050 --> 00:01:21.420 align:middle line:84% because really, that sum total just gives us 00:01:21.420 --> 00:01:24.842 align:middle line:84% a giant number that's total of the entire column. 00:01:24.842 --> 00:01:27.300 align:middle line:84% So what I want to do now is I'm going to go ahead and click 00:01:27.300 --> 00:01:30.060 align:middle line:90% on Output the Results. 00:01:30.060 --> 00:01:32.370 align:middle line:84% And I need to find a place to put these. 00:01:32.370 --> 00:01:33.870 align:middle line:84% So I'm going to come back over here, 00:01:33.870 --> 00:01:37.050 align:middle line:84% right there, because I want to use an empty cell. 00:01:37.050 --> 00:01:38.790 align:middle line:84% So I'm then going to click OK, and it's 00:01:38.790 --> 00:01:40.624 align:middle line:84% going to go ahead and give me those results. 00:01:40.624 --> 00:01:42.456 align:middle line:84% So you're going to, again, have your count-- 00:01:42.456 --> 00:01:43.320 align:middle line:90% 549. 00:01:43.320 --> 00:01:48.490 align:middle line:84% We now know that the minimum was 24 and the maximum was 120. 00:01:48.490 --> 00:01:51.420 align:middle line:90% The mean was 63.48. 00:01:51.420 --> 00:01:52.920 align:middle line:90% The median was 64. 00:01:52.920 --> 00:01:54.870 align:middle line:90% The mode was 69. 00:01:54.870 --> 00:01:56.220 align:middle line:90% The range is 96. 00:01:56.220 --> 00:01:59.280 align:middle line:84% Of course, that's maximum subtracted 00:01:59.280 --> 00:02:00.890 align:middle line:90% by the minimum, which is 96. 00:02:00.890 --> 00:02:02.670 align:middle line:84% Then we get our standard deviation. 00:02:02.670 --> 00:02:05.670 align:middle line:90% In this case, it's 17.22. 00:02:05.670 --> 00:02:07.880 align:middle line:84% When we look at our skewness, it is positive, 00:02:07.880 --> 00:02:10.500 align:middle line:84% so we know that this is positively skewed. 00:02:10.500 --> 00:02:12.490 align:middle line:84% And our Kurtosis is also positive. 00:02:12.490 --> 00:02:15.150 align:middle line:84% Therefore, we know that these numbers are more 00:02:15.150 --> 00:02:17.520 align:middle line:90% peaked than they are flat. 00:02:17.520 --> 00:02:20.910 align:middle line:84% And so that's all that it takes to run descriptive statistics 00:02:20.910 --> 00:02:23.300 align:middle line:90% using Excel. 00:02:23.300 --> 00:02:37.082 align:middle line:90%