00:01
So we're going to be looking at taxi times on the runway, and we'll go to set 15 in appendix b.
00:09
We'll find the range, variance, and standard deviation of these things.
00:15
So to start us off, we can find the range quite easily.
00:19
What we have to do is subtract our largest value from our smallest value, or high and low.
00:25
So that's going to be 49 and 12.
00:29
Take the difference between that to get our range, and that's the.
00:32
37.
00:35
And since we're looking at minutes as our units, we're going to tack on that.
00:40
Minutes.
00:43
Now for the variance, there's a couple of data values here.
00:47
We have a sample size of 48, so quite a few numbers to go through.
00:53
What i would recommend doing is in excel, you write down all of the 48 values, enter them down, you know, 1 through 48.
01:05
In this column, let's call that a.
01:08
And then in column b i want you to find what the average is actually that's not you're just going to be this going to be a single cell so all you have to do is say highlight a single cell in there and in there you're going to write equals mean actually no go for average so average maybe it's avg or abg average so so you'll just open the parentheses, highlight all these cells here, and that's what you'll highlight.
01:52
And then that'll give you your average.
01:56
Then what you can do is copy that number that you get into a second column.
02:02
Let's call that column c.
02:06
And then what you'll do is say that this equals, open through parentheses, highlight the first cell, and then subtract it from the mean, which is in b...