Purchase Solution

Birth Weights: Mean, median, mode, and more

Not what you're looking for?

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.
 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.

Solution Summary

The Excel file contains all of the computations, distributions and graphs required. The Word file contains the reflection paper which is over 650 words long, and includes graphs and tables.

Solution Preview

June was the most common birth month, followed by January and March. The least common birth month was February. Almost three times as many births occurred in June as did in February.

 Report on the statistical values found for this data; what information did you learn from the statistics on this data?
The statistics for the data are as follows:
Mean 116.9
Median 118
Mode 126
25th 104.0
75th 129.1
Minimun 68
Maximum 168
Standard dev 19.4

The lowest birth weight was 68 ounces. The highest birth weight was 168 ounces. The mean birth weight was 116.9 ounces. The standard deviation was 19.4 ounces. The median birth weight was 118 ounces. The most common birth weight was 126 ounces. Half of the birth weights were between 104.0 ...

Solution provided by:
Education
• MSc, California State Polytechnic University, Pomona
• MBA, University of California, Riverside
• BSc, California State Polytechnic University, Pomona
• BSc, California State Polytechnic University, Pomona
Recent Feedback
• "Excellent work. Well explained."
• "Can you kindly take a look at 647530 and 647531. Thanks"
• "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
• "GREAT JOB!!!"
• "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.