00:01
So here we have some data, which is the men's 100 -meter olympic gold and silver medalist times for the past 15 olympics.
00:15
And we're going to do some analysis on this.
00:18
So the first thing we're going to do is calculate the mean time for the gold and silver medalists.
00:25
What's the average time? and for this, i'll call it the sample of the mean, x bar.
00:45
It's the sample of all the limit times.
00:47
So it's the sum of all the x values divided by how many there are.
00:50
There's also a function that we're going to use in excel.
00:55
The average function.
00:57
And what you do is you highlight the data.
01:00
And so we see the averages are 9 .903, the 9 .974.
01:05
So we can see that the mean of the goldmail times is indeed less than the mean of the the silver medal times.
01:12
Now for part b we are going to find the median time, the median time for each.
01:24
And to do that, you would sort them all from least to greatest and then figure out the exact middle value.
01:30
And there's also a function we can use called median.
01:34
And that kind of does that for you, but it picks out the middle value.
01:37
So it's eight, there's 9 .87.
01:42
For the gold, and 9 .96, which appears to be this one, for the silver.
01:49
So you can see the median is less than the silver for the median time for the gold is less than that for the silver.
01:57
All right, the next thing i'm going to do is find the standard deviation of the recorded time for the golden solid amounts, so standard deviation.
02:06
So you go to the square root of the sum of all the values minus the mean squared divided by n minus one.
02:14
That's the formula.
02:16
But again, there's a formula for it, std -e -v -s, because it's a sample of all the gold of all the times.
02:27
And see, they're pretty similar.
02:30
0 .16 for the gold, 0 .15 for the silver.
02:34
So slightly less variation for the silver, but those are pretty small standardizations, especially in regards to the times, the means.
02:41
So that's pretty small.
02:45
Stereivations, here.
02:49
The next thing i'm going to do, and i got this backwards, this is the standard evasion is actually part d, part c, this is to find the range.
02:59
And the range is found by taking the maximum time minus the minimum time...