notes (old) book data ref the dump research links
 

In groups of 2, on paper, you are going to find all of the following:


Real grades from all students at Deering are here.

Find

  • mean
  • median
  • mode
  • range
  • standard deviation
  • on paper, make a boxplot (=Quartile(a:a,1) for 1st quarter)

Find the percentile of the following grades

  1. 91
  2. 94
  3. 74
  4. 85

Find what grade would match the following percentile:

  1. 50%
  2. 25%
  3. 90%
  4. 5%

Birth data:

 

Using this data - real births from BirthTracks.

Review:

  1. Create a new column for pounds (look up conversion between pounds and grams).
  2. Find the mean, standard deviation of this sample of boy births.
  3. Find the mean, standard deviation of this sample of girl births

Lets look at just boys.

 

  1. Find the percentile of the following birth weights
    1. 9.2
    2. 5.5
    3. 7
    4. 10.5
  2. Find what weight would match the following percentile:
    1. 5%
    2. 10%
    3. 25%
    4. 50%
    5. 75%
    6. 90%
    7. 95%

Lets look at just girls.

 

  1. Find the percentile of the following birth weights
    1. 9.2
    2. 5.5
    3. 7
    4. 10.5
  2. Find what weight would match the following percentile:
    1. 5%
    2. 10%
    3. 25%
    4. 50%
    5. 75%
    6. 90%
    7. 95%