American Community Survey summary for the State of Hawaii called ACS_17_1YR_DP_county_all.xls from Sakai.

Download the latest American Community Survey summary for the State of Hawaii called ACS_17_1YR_DP_county_all.xls from Sakai. 1. Find and quote and cite and reference a good definition for Fertility that makes sense based on the numbers presented. What is the question Census Bureau generally asks to get this data? Some info can be found here: https://www.census.gov/topics/health/fertility/about.html 2. Find the fertility per 1000 women numbers for women in these three age groups 15-19, 20 to 34, and 35 – 50 by county. Make a carefully labeled table to show the numbers. 3. State and test hypotheses appropriate for deciding whether age group has any impact on Fertility per 1000 women in Hawaii at the .05 level. 4. State and test hypotheses appropriate for deciding whether County of Residence has any impact on Fertility per 1000 women in Hawaii at the .05 level. 5. Explain why you chose and used the tests you did, and suggest alternate tests you might have used. 6. Explain how your answers to questions 1-5 have changed from what they might have been at the start of the semester.                                                                                                                                                                                                              

Sample Solution