00:02
All right, so we're looking at income in the best places to live in each of the states.
00:11
I put that income into excel.
00:17
All 50 data points are here in excel.
00:21
I'm going to show you how to use excel to find the mean, median, standard deviation, and the quartiles.
00:30
And then we'll go through and calculate the outliers.
00:33
So the mean is the middle.
00:36
It's the average.
00:38
So when you're in excel, you're going to type equals and then average.
00:47
And here it is.
00:48
And then it just wants your numbers.
00:52
Now, you can click and actually i'll just do that this time and highlight all the way down to there.
01:05
And then close it and then i hit equals.
01:10
And if i look back up here, that is going to be my average.
01:16
Okay? to find the median, we're going to hit equals and then start typing median.
01:22
Oh, look, there it is.
01:24
Oh, i forget.
01:25
Don't hit an equal enter, though, because it just doesn't like it.
01:30
Double click on it.
01:32
And i'm just going to type them in, a2, whoops, a2, and a51.
01:40
And that's going to do my whole column.
01:45
And there's the median for our dataset.
01:48
Isn't technology great? all right.
01:51
So standard deviation.
01:54
I'm going to start typing that in.
01:56
And notice there's a couple of them here.
01:59
The one that we want is the one that's dot s, because dot s is for a sample.
02:05
S is for sample.
02:07
And then i'm going to type a to or highlight.
02:11
I don't like to highlight when they're not all in the same page.
02:16
It does weird things for me.
02:20
Okay, and that's our standard deviation.
02:24
Now we're going to find q1 and q3.
02:28
So equal, and i'm going to start typing quartile.
02:33
All right, so we want quartile, and then we're going to, again, a2, a51.
02:47
Two few arguments.
02:49
What did i forget to do? oh, notice down here it says array comma corpse.
02:55
It wants the data values, so what data am i using? and then which quartile do you want? well, i want the first quartile.
03:07
That's the first quartile.
03:09
Now for the third quartile, i'm going to still do a2 to a51, but now i'm going to do three because i want the third quartile.
03:26
And there.
03:30
Excel has excelled at finding mean standard deviation in q1, q3.
03:39
All right.
03:42
Outliers, we're going to go ahead and calculate these out by hand because i think it's important.
03:51
All right, so q1 and q3.
03:59
Q1.
04:00
I'm going to write these down real quick.
04:12
Okay.
04:15
So from excel, we.
04:16
Have q1 is 56 ,801 .50.
04:26
And then q3 is 81 .305.
04:37
Now to find the iqr, we're going to do q3 minus q1.
04:46
So when we subtract these, we get $24 ,733.
05:05
And 80 cents.
05:17
All right.
05:18
So that's the iqr.
05:20
And now to find the outliers, we're going to do 1 .5 times the iqr.
05:27
And then we're going to subtract it from q1 and add it to q3.
05:31
So let's do 1 .5 times the iqr first...