00:01
Okay, i didn't see your data anywhere on the thing.
00:08
So i couldn't use your actual earthquake data, so i just grab some data i have and i can show you how to do everything in excel.
00:25
Okay, just looking over what you need real quick.
00:28
Okay, so first thing we want to find the mean.
00:32
In excel, they call that the average.
00:34
So we're going to add them up and divide by 11, because that's how many things i have here.
00:43
For an excel, i can just hit equals average and voila.
00:48
5 ,400 is the average for my data here, cuba's ppp.
00:54
Standard deviation.
00:55
I type in st, and then i'm going to go to this one that says stv -b .p.
01:03
Now, that is for a population.
01:06
And i know that's the one we're using because on your assignment, your answers, it has...
01:22
This minute, sorry.
01:26
Let me finish this, and then i'll show you.
01:29
Put in the data.
01:34
And hit enter.
01:42
This little thing.
01:44
That means population standard deviation.
01:49
S -d standard deviation.
01:51
Okay.
01:52
Now, i want to go through and find my five number summary in this.
01:59
Q1, q3, et cetera.
02:01
The first thing i need to do is put it in order.
02:04
So i'm going to go to home.
02:05
And that's one of the reasons i like excel, because it will easily sort.
02:10
Everything for me...