Return to Video

Udacians Facebook Friends - Median - Intro to Descriptive Statistics

  • 0:00 - 0:05
    What if we wanted to find the median number of friends using this spreadsheet?
  • 0:05 - 0:09
    Remember, that first we want to order the date. So, there's a very useful tool
  • 0:09 - 0:14
    called Sort which is in pretty much all spreadsheet software. In Google
  • 0:14 - 0:19
    spreadsheets, the way you do it is by first highlighting the data. And I'm
  • 0:19 - 0:23
    going to show you a keyboard shortcut really quick. From cell A2, hit Shift and
  • 0:23 - 0:31
    then Right arrow key, so it highlights cell A2 and B2. And then, Command,
  • 0:31 - 0:36
    Shift, Down arrow key. And then, this highlights all the data. It's easier to
  • 0:36 - 0:39
    do it this way than by simply dragging your cursor all the way down to the
  • 0:39 - 0:44
    bottom. This is just a quick and easy way to highlight all the data. So now,
  • 0:44 - 0:48
    click on Data, and we want to sort by column B because that's the data we're
  • 0:48 - 0:54
    interested in. We're not really interested in the time stamp. So we'll click
  • 0:54 - 0:59
    Sort Range, and then we should get a box here saying, Sort Range By, and we'll
  • 0:59 - 1:06
    say column B. And in general, we want to sort from least to greatest. So, I'm
  • 1:06 - 1:11
    going to stop here and let you try and experiment with this. And then after you
  • 1:11 - 1:15
    sort the data in the spreadsheet, try finding the median
タイトル:
Udacians Facebook Friends - Median - Intro to Descriptive Statistics
概説:

more » « less
Video Language:
English
Team:
Udacity
プロジェクト:
UD827 - Intro to Descriptive Statistics
Duration:
01:16

English subtitles

改訂 Compare revisions