I have attached the excel table that I completed fro the CDC wonder website (choosing California from 2007-2014). So what I need is to verify the information before you complete the assignment so I will have the correct answers.

***

• Go the CDC Wonder website, My state is California

In the second part of this assignment, you will undertake some formal statistical procedures with the natality data. We will repeat the previous steps, with some slight modifications.
 

• Return to the CDC Wonder website.
• Click on Births under the WONDER Online Databases to get to the Natality Information screen.
• Select Natality for 2007 – 2012.
• On the next screen, click I Agree in order to agree to abide by the government rules for data use (primarily, concerning confidentiality).
• This will bring us to the Natality, 2007-2012 Request screen.
  • In block 1. Organize table layout, group results by race and then gender (not year).
  • In block 2. Select maternal residence, choose your state.
  • You can leave block 3 at its default values (typically, All).
  • In block 4. Select birth characteristics; select All Years under Year, and 1st child born alive to mother under Live Birth Order.
  • Blocks 5 and 6 can be left at their default values.
• Click Send. A new screen will open, with data (births) tabulated by race and gender.
• Click Export, click Save, and a text file named Natality 2007-2012.txt (or something similar) will be downloaded onto your computer.
• Return to the data you just generated in the second part of the Week Two assignment. You should have total numbers of first-born boys and girls in your state between the years 2007 and 2012 separately by racial group: American Indians or Alaska Natives, Asian or Pacific Islanders, Black or African Americans, and Whites. For the first part of this discussion, construct and report the 95% confidence intervals for the proportions of first-born boys, separately for each racial group. (Use the normal approximation to the binomial distribution.) Comment on the confidence intervals: can you infer from the confidence intervals that the proportions of first-born boys differ among the racial groups? Explain what the widths of the confidence intervals tell you.
• Leading up to elections, you often hear results of polls of voters’ preferences, with statements such as: “This poll was taken from a random sample of 600 potential voters, and has an accuracy exceeding 96%.” You may want to interpret the accuracy statement in terms of “margin of error”, as explained in the text, Section 6-2. Remember, the width of a confidence interval is a measure of the precision of the estimate.