2018 State Surveys 2018 Poverty Race Health CareEducation Business Housing Median Earnings StatesPopulation Median Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African...

1 answer below »
I need census data loaded into a spreadsheet for 16 states(Kentucky-North Carolina) for a 4-year span. I have 1 year loaded I just need the other 4 years.


2018 State Surveys 2018PovertyRaceHealth CareEducationBusinessHousingMedian Earnings StatesPopulation Median Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Alabama4,887,871$ 49,86117%24%53%8.6%4.3%26.7%67.7%5.6%10.0%31%34%9,958,400$ 68,970,623$ 58,564,96568%$ 147,900$ 788$ 35,854$ 49,210$ 7.25Alabama Alaska737,438$ 74,34611%14%60%12.6%7.2%3.4%64.4%32.2%12.6%28%28%21,077$ 152,392$ 10,474,27566%$ 276,100$ 1,177$ 49,020$ 61,226$ 9.84Alaska Arizona7,171,646$ 59,24614%20%56%9.0%31.6%4.7%78.0%17.3%10.6%24%39%139,134$ 106,431,260$ 84,716,54265%$ 241,100$ 1,036$ 40,311$ 47,854$ 10.50Arizona Arkansas3,013,825$ 47,06217%25%55%8.1%7.6%15.2%76.5%8.3%8.2%34%31%65,611$ 40,969,051$ 36,815,25666%$ 133,100$ 731$ 36,042$ 42,364$ 9.25Arkansas California39,557,045$ 75,27713%17%60%5.1%39.3%5.8%59.5%34.8%7.2%21%42%922,477$ 886,643,923$ 481,800,46155%$ 546,800$ 1,520$ 49,009$ 55,646$ 11.00California Colorado5,695,564$ 71,95310%12%65%8.4%21.7%4.2%84.1%12.8%7.5%21%50%165,264$ 120,398,734$ 67,815,20065%$ 373,300$ 1,289$ 46,498$ 56,377$ 10.20Colorado Connecticut 3,572,665$ 76,34810%14%62%5.8%16.5%11.0%75.2%13.8%5.3%27%48%89,416$ 94,658,647$ 51,632,46766%$ 277,400$ 1,171$ 55,155$ 65,948$ 10.10Connecticut Delaware967,171$ 64,80513%19%58%8.8%9.5%22.5%68.2%9.3%5.7%33%39%25,366$ 21,196,371$ 14,456,00171%$ 255,300$ 1,108$ 43,803$ 51,923$ 8.25Delaware Florida21,299,325$ 55,46214%20%55%8.5%26.1%16.0%74.6%9.4%13.0%29%40%546,218$ 363,336,322$ 273,867,14566%$ 230,600$ 1,182$ 37,821$ 44,520$ 8.25Florida Georgia10,519,475$ 58,75614%21%60%7.6%9.7%31.6%58.3%10.1%13.7%28%40%228,330$ 182,911,144$ 119,801,49564%$ 189,900$ 1,008$ 40,254$ 50,133$ 5.15Georgia Hawaii1,420,491$ 80,2129%12%60%9.6%10.7%2.0%24.3%73.6%4.1%27%45%32,350$ 22,892,445$ 18,901,74558%$ 631,700$ 1,613$ 42,584$ 51,413$ 10.10Hawaii Idaho1,754,208$ 55,58312%14%59%9.3%12.7%0.7%89.9%9.4%11.1%28%38%45,826$ 22,243,275$ 20,444,27871%$ 233,100$ 848$ 36,848$ 47,182$ 7.25Idaho Illinois12,741,080$ 65,03012%16%62%5.7%17.3%14.1%71.7%14.2%7.0%26%43%319,605$ 295,308,470$ 166,634,51466%$ 203,400$ 995$ 45,910$ 56,838$ 8.25Illinois Indiana 6,691,878$ 55,74613%18%61%7.4%7.1%9.5%82.8%7.7%8.3%33%36%146,078$ 117,009,032$ 85,857,96269%$ 147,300$ 820$ 38,031$ 50,774$ 7.25Indiana Iowa3,156,145$ 59,95511%14%65%7.6%6.1%3.6%90.2%6.2%4.7%31%41%81,563$ 56,930,435$ 44,905,62471%$ 152,000$ 777$ 40,353$ 51,488$ 7.25Iowa Kansas2,911,510$ 58,21812%15%63%8.2%12.0%5.9%84.0%10.0%8.8%25%43%74,884$ 51,016,318$ 38,276,46166%$ 159,400$ 840$ 40,045$ 50,872$ 7.25Kansas Kentucky4,468,402$ 50,24717%23%56%7.6%3.6%7.9%86.7%5.4%5.6%33%33%92,000$ 65,242,827$ 54,869,97867%$ 135,300$ 1,135$ 37,379$ 47,370$ 7.25Kantucky Louisiana4,659,978$ 47,90519%26%55%7.0%5.1%32.4%61.7%5.9%8.0%34%31%105,732$ 75,125,447$ 61,396,36466%$ 167,300$ 854$ 35,758$ 51,453$ 7.25Louisiana Maine1,338,404$ 55,60212%15%61%9.7%1.7%1.4%94.3%4.2%8.0%31%41%41,178$ 21,349,199$ 21,521,71471%$ 197,500$ 839$ 40,421$ 48,522$ 10.00Maine Maryland6,042,718$ 83,2429%12%64%7.8%10.4%30.0%54.7%15.3%6.0%24%48%138,480$ 121,952,023$ 76,379,70767%$ 324,800$ 1,371$ 53,421$ 62,167$ 10.10Maryland Massachusetts6,902,149$ 79,83510%12%64%5.3%12.3%7.8%77.3%14.8%2.8%23%52%177,631$ 204,747,200$ 92,915,38062%$ 400,700$ 1,295$ 55,942$ 67,147$ 11.00Massachusetts Michigan9,995,915$ 56,69714%19%58%6.8%5.2%13.8%78.3%7.9%5.4%29%39%220,412$ 183,192,569$ 119,302,04671%$ 162,500$ 861$ 41,205$ 52,332$ 9.25Michigan Minnesota 5,611,179$ 70,31510%12%67%6.8%5.5%6.6%82.5%10.9%4.4%24%48%150,115$ 137,135,936$ 78,898,18272%$ 235,400$ 969$ 46,861$ 56,809$ 9.86Minnesota Mississippi2,986,530$ 44,71720%28%52%7.2%2.9%………12.1%30%33%58,850$ 34,356,961$ 37,053,190…$ 123,300$ 777$ 33,530$ 44,495$ 7.25Mississippi Missouri6,126,452$ 54,47813%18%60%8.1%4.1%11.5%82.2%6.3%9.4%30%38%160,912$ 112,072,115$ 90,546,58167%$ 162,600$ 830$ 38,414$ 49,109$ 7.85Missouri Montana1,062,305$ 55,32813%16%61%10.2%3.9%0.5%88.6%10.9%8.2%28%41%37,626$ 14,542,766$ 15,623,57368%$ 249,200$ 811$ 36,741$ 48,037$ 8.30Montana Nebraska1,929,268$ 59,56611%13%66%8.1%11.1%4.7%86.4%9.0%8.3%26%43%54,265$ 37,715,004$ 30,470,71766%$ 161,800$ 830$ 40,156$ 50,286$ 9.00Nebraska Nevada3,034,392$ 58,64613%18%60%9.0%29.0%9.2%63.4%27.2%11.2%28%33%64,815$ 49,207,817$ 38,234,17057%$ 292,200$ 1,108$ 40,004$ 46,556$ 8.25Nevada New Hampshire1,356,458$ 74,9918%11%65%8.6%3.9%1.7%92.4%5.9%5.7%28%47%37,868$ 29,193,307$ 26,018,20171%$ 270,000$ 1,090$ 45,346$ 61,045$ 7.25New Hampshire New Jersey8,908,520$ 81,74010%14%63%4.4%20.6%13.6%66.9%19.5%7.4%26%47%231,974$ 214,757,817$ 133,665,72864%$ 344,000$ 1,336$ 52,383$ 66,532$ 8.60New Jersey New Mexico2,095,428$ 47,16920%26%52%9.1%49.1%2.2%76.5%21.4%9.5%26%36%43,771$ 25,029,224$ 25,179,27466%$ 174,400$ 830$ 35,683$ 42,673$ 7.50New Mexico New York19,542,209$ 67,84414%19%60%4.4%19.2%15.7%63.3%20.8%5.4%26%46%544,073$ 521,872,694$ 251,167,73654%$ 325,500$ 1,274$ 50,921$ 58,064$ 10.40New York North Carolina 10,383,620$ 53,85514%20%58%8.3%9.6%21.4%68.4%10.3%10.7%25%42%227,347$ 170,980,033$ 120,691,00765%$ 180,600$ 900$ 39,126$ 46,941$ 7.25North carolina North Dakota760,077$ 63,83711%10%67%7.8%3.6%3.4%85.7%10.8%7.3%26%45%24,601$ 15,816,748$ 15,519,81663%$ 198,700$ 808$ 40,582$ 55,608$ 7.25North Dakota Ohio$ 8.30Ohio Oklahoma$ 7.25Oklahoma Oregon$ 10.75Oregon Pennsylvania$ 7.25Pennsylvania Rhode Island$ 10.10Rhode Island South Carolina5,084,127$ 52,30615%23%56%9.2%5.7%26.6%67.0%6.4%10.5%88%39%105,959$ 69,050,740$ 58,093,82469%$ 170,800$ 892$ 36,720$ 46,080$ 7.25South Carolina South Dakota$ 8.85South Dakota Tennesse$ 7.25Tennesse Texas$ 7.25Texas Utah$ 7.25Utah Vermont$ 10.50Vermont Virginia $ 7.25Virginia Washington$ 11.50Washington West Virgina$ 8.75West Virgina Wisconsin$ 7.25Wisconsin Wyoming$ 5.15Wyoming United States 6525299.0857142961890.85714285710.12882857140.17342857140.59922857140.07877142860.12740.11391176470.74285294120.14341176470.08105714290.29462857140.4053428571439405.942857143130125967.68428683500330.82857140.6577647059242142.8571428571020.371428571442232.314285714352428.48.453 Referenceshttps://data.census.gov/cedsci/profile?q=United%20States&g=0100000US#https://www.dol.gov/agencies/whd/state/minimum-wage/history https://www.dol.gov/agencies/whd/state/minimum-wage/historyhttps://data.census.gov/cedsci/profile?q=United%20States&g=0100000US 2009 Column1Population Median Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Kentucky4,339,36710%3%8%86%3%29%35% Louisiana4,533,372 Maine1,328,361 Maryland5,773,552 Massachusetts6,547,629 Michigan9,883,640 Minnesota 5,303,925 Mississippi2,967,297 Missouri5,988,927 Montana989,415 Nebraska1,826,341 Nevada2,700,551 New Hampshire1,316,470 New Jersey8,791,894 New Mexico2,059,179 New York19,378,102 North Carolina 9,535,483 2017 Column1PopulationMedian Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina 2016 Column1PopulationMedian Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico 2015 Column1PopulationMedian Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico
Answered Same DayApr 24, 2021

Answer To: 2018 State Surveys 2018 Poverty Race Health CareEducation Business Housing Median Earnings...

Sudharsan.J answered on Apr 26 2021
129 Votes
2018
    State Surveys 2018            Poverty                Race                Health Care    Education        Business            Housing            Median Earnings
    States    Population     Median Household Income    Poverty Rate    Under 18    Empolyment Rate    Veterans    Hispanic     African American    White     Other    Uninsured     Highschool Grad    Higher Education (Degree Holding)    Total Employers    Annual Payroll    Retail Sales    Homeownership    Housing Value     Renter Costs    Female    Male    
Minimum Wage (State Law)
    Alabama    4,887,871    $ 49,861    17%    24%    53%    8.6%    4.3%    26.7%    67.7%    5.6%    10.0%    31%    34%    9,958,400    $ 68,970,623    $ 58,564,965    68%    $ 147,900    $ 788    $ 35,854    $ 49,210    $ 7.25    Alabama
    Alaska    737,438    $ 74,346    11%    14%    60%    12.6%    7.2%    3.4%    64.4%    32.2%    12.6%    28%    28%    21,077    $ 152,392    $ 10,474,275    66%    $ 276,100    $ 1,177    $ 49,020    $ 61,226    $ 9.84    Alaska
    Arizona    7,171,646    $ 59,246    14%    20%    56%    9.0%    31.6%    4.7%    78.0%    17.3%    10.6%    24%    39%    139,134    $ 106,431,260    $ 84,716,542    65%    $ 241,100    $ 1,036    $ 40,311    $ 47,854    $ 10.50    Arizona
    Arkansas    3,013,825    $ 47,062    17%    25%    55%    8.1%    7.6%    15.2%    76.5%    8.3%    8.2%    34%    31%    65,611    $ 40,969,051    $ 36,815,256    66%    $ 133,100    $ 731    $ 36,042    $ 42,364    $ 9.25    Arkansas
    California    39,557,045    $ 75,277    13%    17%    60%    5.1%    39.3%    5.8%    59.5%    34.8%    7.2%    21%    42%    922,477    $ 886,643,923    $ 481,800,461    55%    $ 546,800    $ 1,520    $ 49,009    $ 55,646    $ 11.00    California
    Colorado    5,695,564    $ 71,953    10%    12%    65%    8.4%    21.7%    4.2%    84.1%    12.8%    7.5%    21%    50%    165,264    $ 120,398,734    $ 67,815,200    65%    $ 373,300    $ 1,289    $ 46,498    $ 56,377    $ 10.20    Colorado
    Connecticut     3,572,665    $ 76,348    10%    14%    62%    5.8%    16.5%    11.0%    75.2%    13.8%    5.3%    27%    48%    89,416    $ 94,658,647    $ 51,632,467    66%    $ 277,400    $ 1,171    $ 55,155    $ 65,948    $ 10.10    Connecticut
    Delaware    967,171    $ 64,805    13%    19%    58%    8.8%    9.5%    22.5%    68.2%    9.3%    5.7%    33%    39%    25,366    $ 21,196,371    $ 14,456,001    71%    $ 255,300    $ 1,108    $ 43,803    $ 51,923    $ 8.25    Delaware
    Florida    21,299,325    $ 55,462    14%    20%    55%    8.5%    26.1%    16.0%    74.6%    9.4%    13.0%    29%    40%    546,218    $ 363,336,322    $ 273,867,145    66%    $ 230,600    $ 1,182    $ 37,821    $ 44,520    $ 8.25    Florida
    Georgia    10,519,475    $ 58,756    14%    21%    60%    7.6%    9.7%    31.6%    58.3%    10.1%    13.7%    28%    40%    228,330    $ 182,911,144    $ 119,801,495    64%    $ 189,900    $ 1,008    $ 40,254    $ 50,133    $ 5.15    Georgia
    Hawaii    1,420,491    $ 80,212    9%    12%    60%    9.6%    10.7%    2.0%    24.3%    73.6%    4.1%    27%    45%    32,350    $ 22,892,445    $ 18,901,745    58%    $ 631,700    $ 1,613    $ 42,584    $ 51,413    $ 10.10    Hawaii
    Idaho    1,754,208    $ 55,583    12%    14%    59%    9.3%    12.7%    0.7%    89.9%    9.4%    11.1%    28%    38%    45,826    $ 22,243,275    $ 20,444,278    71%    $ 233,100    $ 848    $ 36,848    $ 47,182    $ 7.25    Idaho
    Illinois    12,741,080    $ 65,030    12%    16%    62%    5.7%    17.3%    14.1%    71.7%    14.2%    7.0%    26%    43%    319,605    $ 295,308,470    $ 166,634,514    66%    $ 203,400    $ 995    $ 45,910    $ 56,838    $ 8.25    Illinois
    Indiana     6,691,878    $ 55,746    13%    18%    61%    7.4%    7.1%    9.5%    82.8%    7.7%    8.3%    33%    36%    146,078    $ 117,009,032    $ 85,857,962    69%    $ 147,300    $ 820    $ 38,031    $ 50,774    $ 7.25    Indiana
    Iowa    3,156,145    $ 59,955    11%    14%    65%    7.6%    6.1%    3.6%    90.2%    6.2%    4.7%    31%    41%    81,563    $ 56,930,435    $ 44,905,624    71%    $ 152,000    $ 777    $ 40,353    $ 51,488    $ 7.25    Iowa
    Kansas    2,911,510    $ 58,218    12%    15%    63%    8.2%    12.0%    5.9%    84.0%    10.0%    8.8%    25%    43%    74,884    $ 51,016,318    $ 38,276,461    66%    $ 159,400    $ 840    $ 40,045    $ 50,872    $ 7.25    Kansas
    Kentucky    4,468,402    $ 50,247    17%    23%    56%    7.6%    3.6%    7.9%    86.7%    5.4%    5.6%    33%    33%    92,000    $ 65,242,827    $ 54,869,978    67%    $ 135,300    $ 1,135    $ 37,379    $ 47,370    $ 7.25    Kantucky
    Louisiana    4,659,978    $ 47,905    19%    26%    55%    7.0%    5.1%    32.4%    61.7%    5.9%    8.0%    34%    31%    105,732    $ 75,125,447    $ 61,396,364    66%    $ 167,300    $ 854    $ 35,758    $ 51,453    $ 7.25    Louisiana
    Maine    1,338,404    $ 55,602    12%    15%    61%    9.7%    1.7%    1.4%    94.3%    4.2%    8.0%    31%    41%    41,178    $ 21,349,199    $ 21,521,714    71%    $ 197,500    $ 839    $ 40,421    $ 48,522    $ 10.00    Maine
    Maryland    6,042,718    $ ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here