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.
Report on your findings about the birth months.
Report on the statistical values found for this data; what information did you learn from the statistics on this data?
Compare the data with the following data from the United States.
o Birth weights in the U.S. are normally distributed with the mean of 3520 grams and a standard deviation of 460 grams
How is the data distributed? Is it skewed or symmetrical, how do you know? What does distribution tell you about the data?
Interpret the meaning of the z-score for your data value. Explain what the z-score tells you about your value.
Explain your process for making the frequency tables and graphs. Explain how Excel was used and any calculations are done.