[Script Info]
Title:
[Events]
Format: Layer, Start, End, Style, Name, MarginL, MarginR, MarginV, Effect, Text
Dialogue: 0,0:00:00.01,0:00:06.75,Default,,0000,0000,0000,,>> So, here's the data and you see that people entered this data on January 2nd,
Dialogue: 0,0:00:06.75,0:00:13.39,Default,,0000,0000,0000,,and that the data goes all the way down to cell B28, right here, and it starts
Dialogue: 0,0:00:13.39,0:00:20.61,Default,,0000,0000,0000,,at cell B2. Now, we can calculate the average anywhere in this white space. So,
Dialogue: 0,0:00:20.61,0:00:27.95,Default,,0000,0000,0000,,let's pick this one, looks like a good cell, good old cell D4. So, we'll write
Dialogue: 0,0:00:27.95,0:00:35.78,Default,,0000,0000,0000,,equals average of cell B2 all the way to B28. Now, we'll just make sure that all
Dialogue: 0,0:00:35.78,0:00:43.29,Default,,0000,0000,0000,,of the data is highlighted with this dotted green line. That way, we know that
Dialogue: 0,0:00:43.29,0:00:49.72,Default,,0000,0000,0000,,we are accounting for all of these data. And then we push Enter. So, you should
Dialogue: 0,0:00:49.72,0:00:56.38,Default,,0000,0000,0000,,have gotten that the average Udacian, at least in this sample, has 585 Facebook
Dialogue: 0,0:00:56.38,0:01:04.17,Default,,0000,0000,0000,,friends. Another way to do that is to sum cells B2 to B28 and then divide by how
Dialogue: 0,0:01:04.17,0:01:11.81,Default,,0000,0000,0000,,many people there are. So, there are 27 people and we get the same thing because
Dialogue: 0,0:01:11.81,0:01:19.81,Default,,0000,0000,0000,,remember, what we just did here when we took the sum of all the data values then
Dialogue: 0,0:01:19.81,0:01:27.48,Default,,0000,0000,0000,,divided by n, that's the formula for the mean, for any dataset. And that's what
Dialogue: 0,0:01:27.48,0:01:32.85,Default,,0000,0000,0000,,you worked with earlier in this lesson. So, spreadsheets are not only useful,
Dialogue: 0,0:01:32.85,0:01:37.64,Default,,0000,0000,0000,,but they're a great way to look at the same concepts in a different way.