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 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.
Purchase this Solution
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
Report on your findings about the birth months.
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 ...
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. "
Purchase this Solution
Free BrainMass Quizzes
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.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.