State county health rankings and the Dartmouth Atlas Memo

    States and localities across the United States vary in population characteristics, health care needs, health care supply, medical practice and health care outcomes. In this paper, you’ll be examining variation using two public use datasets, available on two different interactive websites. You need to complete two tables, and write up the findings for each table in several paragraphs. The data for the first table can be found at countyhealthrankings.org Be sure to read about each of the indicators on the website so that you are clear about how they are measured and interpreted. You must select 2 of the following states to complete the table: Colorado, Georgia, Illinois, New Mexico, New York, Texas. Table 1: State demographic and health system characteristics and health outcomesIndicator Texas New York Average Range Year of Data Average Range Year of DataSocial and demographic indicators Some college 60% 18-80% 2011-2015 67% 47-83% 2011-2015Unemployment 4.5% 2.1-13.6% 2015 5.3% 4.1-7.7% 2015Children in poverty 23% 8-47% 2015 22% 7-43% 2015Income Inequality 4.9 3.2-7.3 2011-2015 5.7 3.8-8.8 2011-2015Uninsured 21% 13-35% 2014 10% 5-16% 2014Provider Supply Primary care physicians 1,670:1 1,960:0-790:1 2014 1,200:1 10,500:1-690:1 2014Mental health providers 1,070:1 16,660:1-410:1 2016 420:1 2,360:1-140:1 2016Health Outcomes Premature Death 6,700 4,000-18,200 2012-2014 5,300 4,100-8,900 2012-2014Poor or fair health 19% 11-42% 2015 16% 10-28% 2015Poor mental health days 3.2 2.9-4.4 2015 3.7 3.2-4.4 2015Low birthweight 8% 5-14% 2008-2014 8% 5-10% 2008-2014System performance Preventable hospital stays 54 30-128 2014 48 24-84 2014Mammography 58% 26-73% 2014 62% 53-73% 2014 Summarize your findings by describing each state in a separate paragraph, and add a third paragraph that makes comparisons across states.         Summarize your findings by describing each state in a separate paragraph, and add a third paragraph that makes comparisons across states. Be sure to describe your data closely. Add interpretation only in the third paragraph.     Table 2: Variation in Health Care in Texas and New YorkIndicator Texas New York High hospital referral region rate within state Low hospital referral region rate within state Year of Data High hospital referral region rate within state Low hospital referral region rate within state Year of DataCancer screening PSA test for those over 75 18.2% 2014 25.6% 22014Mammography for those over 75 19.3% 2014 17.5% 2014Utilization measures % of patients seeing 10 or more MDs in last six months of life 52.2% 2014 56.3% 2014Bariatric surgery 30.1 2007-2011 19.5 2007-2011System performance measures ACS discharges overall 46 2014 43.7 2014Asthma, by race (overall) 1.3 2014 2.5 2014Bacterial pneumonia, by race (overall) 9.5 2014 6.9 2014Diabetes, by race(overall) 2.3 2014 2.7 2014 Summarize your findings, noting within-state differences.