Birth Weights: Mean, median, mode, and more

You will be using data to calculate various statistical values such as: mean, median, mode, maximum, minimum, standard deviation, and z-scores. You will also create tables and graphs to help analyze the data.

1. Convert all the given data to total ounces.

2. Use Excel to find the following statistics for the given data:
 Mean, median, mode, 25th percentile, 75th percentile, minimum, maximum, and Standard deviation of the values.
3. Provide a birth weight value of your own (this could be yours, a family member's, or anyone of interest to you).
 Calculate the z-score for this value.
4. Create visual representations of the data.
 Create a frequency distribution table based on the birth month. Excel's ability to sort data will be useful for this, although you do not have to use Excel to determine the frequencies. See the guide for help on how to sort data.
 Create an appropriate graph based on the frequency of the birth months.
 Create a frequency distribution table of the birth weights for the data. To do this, start by creating intervals for your data beginning with 60 to 69.9, then 70 to 79.9 and so on until there are no more data points. Excel's ability to sort data will be useful for this, although you do not have to use Excel to determine the frequencies.
 Create the appropriate graph based on the frequency of the birth weight class intervals from your frequency distribution table.

5.