Reference no: EM131928162
Statistics Project: Birth Weights
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 within your class.
- Put your name, course name, and project name on your spreadsheet
- 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.
- 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. See the student 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 weightclass intervals from your frequency distribution table.
- Include meaningful labels and titles on your graphs.
5. 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.
- Project should be your original work. Copying someone else's work is cheating. Sharing your work with someone else is cheating.
Attachment:- Data.xlsx
Determine the amount of each coupon
: A bond with face value of $1000 maturing in 21 months pays semi-annual coupons (the remaining coupons will be paid at 3, 9, 15, and 21 months).
|
Compute irr for each project
: Compute i* for each investment. If the problem has more than one i* identify all of them.Compute IRR (true) for each project.
|
What is the firm value of operations
: What is the firm's value of operations, and how many shares will remain after the repurchase (in millions)?
|
Develop a valuation model for the long-term corporate bond
: Develop a valuation model for the long-term corporate bond with a face value at maturity of $100,000, a maturity of 10 years, a coupon interest rate of 6%.
|
Report on your findings about the birth months
: Math 123 Quantitative Reasoning - Calculate various statistical values such as: mean, median, mode, maximum, minimum, standard deviation, and z-scores
|
What is the amount of income tax expense
: The company tax rate is 4%. What is the amount of income tax expense that Southeast should report in its income statement
|
Puckett target capital structure
: Puckett Products is planning for $6 million in capital expenditures next year. Puckett's target capital structure consists of 75% debt and 25% equity.
|
What will the adjusted eps
: The EPS is $12.00, the DPS is $2.50, and the stock sells for $75 per share. Laurence announces a 3-for-1 split. Immediately after the split.
|
What annual rate of return must you have earned
: You invested $10600 and in 5 years it grew to $14100. What annual rate of return (APR) must you have earned. Assume annual compounding.
|