Statistics Project: Birth Weights
Explain your process for making the frequency tables and graphs. In this project, you will be using data to calculate various statistical values such as: mean, median, mode, maximum, minimum, standard deviation and z-scores. You will compare the data to your personal information. You will also create tables and graphs to help analyze the data. You will be asked to reflect on your findings.
In this project you are required to do the following:
1. Download the project data Excel file provided in Ivy Learn.
• Put your name, course name and project name on your spreadsheet
• Convert all the given data to 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.
• Label these values clearly.
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.
• 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 you must first determine what range of values to use for each class interval. 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.
• Include meaningful labels and titles on your graphs.
Write a reflection paper about your findings on this project. Remember that we are looking for elegant and sophisticated answers. Include the following items:
• 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.
• Reflect on the results of your project. What did you learn by doing this project? How might Excel help you analyze data or calculate statistics in the future?
In addition to addressing the statements above, your project should:
• Contain a paper that is well organized and in paragraph form (not just bulleted answers!).
• Contain a paper that is clear to someone who is not familiar with the project. (i.e. don’t assume that you are writing this to your instructor, make sure anyone could understand your statements.)
• Give specific values (i. e. quantify statements).
• Provide support for your statements (e.g. explain how values were found and justify statements).
• Contain a spreadsheet using the original values from the provided Excel file.
• Use appropriate representations (tables, color, formatting) that will help the reader understand the project.
• Have sophisticated and elegant solutions.
• Submit both an Excel and Word file following your instructor’s directions for submission.