FIND A SOLUTION AT Academic Writers Bay
The normal male to female live birth sex ratio ranges from about 1.03 to 1.07. The sex ratio is defined as the ratio of male births to female births. You might expect boy and girl births to be equally likely, but in fact, baby boys are somewhat more common than baby girls.
Higher sex ratios are thought to reflect prenatal sex selection, especially among cultures where sons are prized more heavily than daughters. We will review sex ratios in the United States as a whole, as well as in individual states, to determine whether sex ratios vary significantly among various ethnic and racial groups.
To do this analysis, we will utilize natality data for the United States, provided by the Centers for Disease Control.
In the first part of the assignment, we will look at sex ratios for your home state, over the time period 1995 to 2002, by race. To obtain this information:
Go the CDC Wonder website,
Click on Births under the WONDER Online Databases to bring you to the Natality Information screen
On this screen, click Natality for 1995-2002.
On the following screen, click I Agreein order to agree to abide by the government rules for data use (primarily, concerning confidentiality).
This will bring us to the Natality, 1995-2002 Request screen.
In the block 1. Organize table layout, group results by year, followed by race, and then gender.
In the block 2. Select maternal residence, choose your state.
You can leave blocks 3 through 6 at their default values (i.e., All).
A new screen will open, with data (births) tabulated by Year, Race, and Gender.
Click Export, click Save, and a text file named Natality, _1995-2002 .txt or something similar will be downloaded onto your computer.
We can now process the downloaded data in Excel.
Load the text file into Excel. This will probably open the Text Import Wizard.
Accept the defaults, and you should have a spreadsheet with the natality data entered.
We will need to edit the data slightly before calculating sex ratios and drawing graphs of the sex ratios. To do this:
Scroll down to the end of the spreadsheet, and delete the rows with the extraneous information about the dataset. (This starts on or about row 203.)
You may also delete the columns with headings Year CodeRace Code, and Gender Code since we will not be using them, however this is not necessary.
Next, sort the data, in order to delete some extraneous rows. Select the remaining columns, choose Data > Sort, then sort by Race in ascending order.
Scroll down to the end of the worksheet, and delete all rows with blanks for Race.
We will now add a new column to the worksheet for ratios.
Go to the first blank column in the worksheet: this column should be immediately to the right of a column labeled Births.
In the first row of this column, type Ratios.
Now, we will calculate different proportions of births, using formulas in excel. It is important to use excel to do the calculation, because it will allow you to quickly complete all of the ratios.
First, calculate the ratio of female births to total births for the American Indian race (female births/total births).
Next, calculate the ratio of male births to total births for the American Indian race (male births/total births).
Finally, calculate the ratio of male births to female births (male births/total births)
If you don’t know how to do this calculation easily in Excel, please check out the screencast, which reviews this.
Once you have completed the first three cells in the ratio column, you can select them and copy them.
Select the remaining cells in the column and paste.
You have now completed calculating all of the ratios, however, you may wish to double check to ensure that the formulas have adjusted for each cell.
Once you have the Ratio column filled out, select that column, then Copy.
With the column still selected you want to select, click Paste Special and then Values. This will convert the formulas you entered to numbers, so they do not change when you do the next sort.
Select all the columns, then Data>Sort>Notesin ascending order. We will be graphing the sex ratios for the years 1995 to 2002, by race.
Feel free to drop the two to four races that have the fewest numbers of births in your state.
Draw a line chart with markers with the year along the X-axis (we are looking at 1995 through 2002) and sex ratio along the Y-axis (with sex ratios typically between 1 and 1.1, though this may vary in your state).
If your version of excel has the Chart Wizard:
In step two of the Chart Wizard, choose the Series tab; in this window you’ll be adding all the information for the various plots.
Under category (X) axis labels, drag your mouse over the cells 1995, 1996… 2002.
For values, draw your mouse over the seven successive sex ratios for the particular racial group you chose; in the name box, enter the racial group; do this for each of the groups you want to display.
Select Next when you have finished with all the racial groups, and you will be brought to the Chart Options screen.
Here, you can customize your graph, with a title and X and Y axis labels (i.e., your state births, year, and sex ratio respectively).
Continue with Next, and finish the graph.
If your version of excel does not have the Chart Wizard, you will need to do some reformatting of your data before you can create a line chart. It is good practice to create a new worksheet in order to preserve your original data.
Your data should mimic the way you want your line chart to look. In this case, you want to create horizontal labels for each of the years (1995 through 2002) and vertical labels for each of the races. It should follow this format:
“Looking for a Similar Assignment? Get Expert Help For A ORIGINAL PAPER!”
To do this analysis, we will utilize natality data for the United States, provided by the Centers for Disease Control. was first posted on April 18, 2019 at 6:50 am.©2019 “Lion Essays”. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at [email protected] Essays.com
To do this analysis, we will utilize natality data for the United States, provided by the Centers for Disease Control. Lion Essays.
To do this analysis, we will utilize natality data for the United States, provided by the Centers for Disease Control. was first posted on April 10, 2022 at 1:19 am.©2019 “Lion Essays”. Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at [email protected]
“GET THIS PAPER COMPLETED FOR YOU FROM THE WRITING EXPERTS”
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK ; CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: ORIGINAL PAPER – NO PLAGIARISM - CUSTOM PAPER
Why Choose Us?
- non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How It Works
- Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT ; SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
AcademicWritersBay.comnbsp;is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.
AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient andnbsp;high quality academic servicesnbsp;to our highly esteemed clients. AcademicWritersBay.com is equipped with competent andnbsp;proficient writersnbsp;to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders ofnbsp;master's degreesnbsp;ornbsp;PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. Atnbsp;AcademicWritersBay.com, you can be sure ofnbsp;excellent gradesnbsp;in your assignments and final exams.