1
00:00:00,240 --> 00:00:01,620
Now that we've got some bounds for
2
00:00:01,620 --> 00:00:05,000
our data, it would be nice
to know where the middle is.
3
00:00:05,000 --> 00:00:08,285
Unfortunately, there is a few
different ways to define the middle.
4
00:00:08,285 --> 00:00:10,390
Let's look at three of them.
5
00:00:10,390 --> 00:00:13,610
The first and most common way to
look at the middle of a data set
6
00:00:13,610 --> 00:00:16,890
is to use the mean,
also known as the average.
7
00:00:16,890 --> 00:00:20,260
To find the average of a set,
add up all the values and
8
00:00:20,260 --> 00:00:22,980
then divide by how many values there are.
9
00:00:22,980 --> 00:00:27,390
One problem with averages is that
they're easily influenced by outliers.
10
00:00:27,390 --> 00:00:29,850
If we're looking at these
eight bowling scores,
11
00:00:29,850 --> 00:00:33,620
the average is higher than every value but
the highest.
12
00:00:33,620 --> 00:00:36,830
In this case, instead of using
the average to find the middle,
13
00:00:36,830 --> 00:00:39,330
it might be better to use the median.
14
00:00:39,330 --> 00:00:42,990
The median represents
the middle value in a data set.
15
00:00:42,990 --> 00:00:48,050
If your data set has an even number of
values and thus no true middle value,
16
00:00:48,050 --> 00:00:51,710
then the median is the average
of the two middle values.
17
00:00:51,710 --> 00:00:56,320
So for our bowling data set,
the median value would be 115, which
18
00:00:56,320 --> 00:01:00,700
does a much better job of representing
the middle than the average did.
19
00:01:00,700 --> 00:01:04,170
The last way we can try and
find the middle is to use the mode.
20
00:01:04,170 --> 00:01:07,520
The mode is them most frequent
value in our data set.
21
00:01:07,520 --> 00:01:12,510
In our bowling data set, there's only one
repeated value, so our mode has to be 90.
22
00:01:12,510 --> 00:01:17,210
Back in the spreadsheet, let's calculate
these values for our data set.
23
00:01:17,210 --> 00:01:21,482
Let's add the labels starting at A5,
average,
24
00:01:21,482 --> 00:01:26,070
median and mode.
25
00:01:26,070 --> 00:01:31,220
And then let's highlight those labels and
hit command or ctrl B to make them bold.
26
00:01:31,220 --> 00:01:35,685
Then in column B let's use functions
to figure out these values.
27
00:01:35,685 --> 00:01:40,373
In B5, let's type =AVERAGE.
28
00:01:40,373 --> 00:01:47,035
Hit Enter to select it, paste in our
range, hit Enter again and there we go.
29
00:01:47,035 --> 00:01:51,670
Now let's do the same thing for
the median and mode.
30
00:01:51,670 --> 00:01:56,411
Type in the function,
31
00:01:56,411 --> 00:02:03,902
paste in the range, and hit Enter.
32
00:02:03,902 --> 00:02:06,341
And there we go, except for the mode,
33
00:02:06,341 --> 00:02:10,180
looks like it's not using
the right data type.
34
00:02:10,180 --> 00:02:11,640
So let's click this button up here, and
35
00:02:12,690 --> 00:02:17,450
instead of Automatic
let's set it to Duration.
36
00:02:18,510 --> 00:02:19,990
There we go.
37
00:02:19,990 --> 00:02:24,218
All right, not only do we have information
about the edges of our data but
38
00:02:24,218 --> 00:02:27,310
now we have a pretty good
idea of where the middle is.
39
00:02:27,310 --> 00:02:29,280
If you'd like to learn more about mean,
median and
40
00:02:29,280 --> 00:02:31,450
mode, check out the teacher's notes.
41
00:02:31,450 --> 00:02:34,790
Coming up, we'll look at a few ways
to figure out the spread of our data.