• The Amara On Demand team is looking for native speakers of German, Japanese, Korean, Italian, Hindi and Dutch to help with special paid projects
Apply here 非表示にする

← Udacians Facebook Friends - Mean - Intro to Descriptive Statistics

• 2 フォロワーs
• 14 Lines

埋め込みコードを取得する x Embed video Use the following code to embed this video. See our usage guide for more details on embedding. Paste this in your document somewhere (closest to the closing body tag is preferable): ```<script type="text/javascript" src='https://amara.org/embedder-iframe'></script> ``` Paste this inside your HTML body, where you want to include the widget: ```<div class="amara-embed" data-url="http://www.youtube.com/watch?v=ljBJOXJTR9A" data-team="udacity"></div> ``` 4言語

Showing Revision 3 created 05/25/2016 by Udacity Robot.

1. >> So, here's the data and you see that people entered this data on January 2nd,
2. and that the data goes all the way down to cell B28, right here, and it starts
3. at cell B2. Now, we can calculate the average anywhere in this white space. So,
4. let's pick this one, looks like a good cell, good old cell D4. So, we'll write
5. equals average of cell B2 all the way to B28. Now, we'll just make sure that all
6. of the data is highlighted with this dotted green line. That way, we know that
7. we are accounting for all of these data. And then we push Enter. So, you should
8. have gotten that the average Udacian, at least in this sample, has 585 Facebook
9. friends. Another way to do that is to sum cells B2 to B28 and then divide by how
10. many people there are. So, there are 27 people and we get the same thing because
11. remember, what we just did here when we took the sum of all the data values then
12. divided by n, that's the formula for the mean, for any dataset. And that's what
13. you worked with earlier in this lesson. So, spreadsheets are not only useful,
14. but they're a great way to look at the same concepts in a different way.