Sheet 1 HMGTFINALEXAM1...

The main idea of the final exam is to evaluate students analytical skills. For the final exam, students will need to useExcel


Sheet 1 HMGTFINALEXAM1 hospital_bedstotal_hospital_employees_on_payrtotal_hospital_non_paid_workersinterns_and_residentssystem_membertotal_hosp_costtotal_hosp_revenuetotal_hospital_medicare_daystotal_hospital_medicaid_daystotal_hospital_medicare_dischargtotal_hospital_dischargespct_female_under_povertypct_male_under_povertytotal_populationmedian_hh_incomestateabbrevstatenamefipsherf_indexherf_catherf_insyearowntotal_hospital_medicaid_dischargteaching_hospitallog_hosp_revenuepct_poverty 14802097046172.68E+0816538.376955311.2768553209.5805669345.22363311.46.712314357809NHNew Hampshire33017102201212867019.4049418.1 356114615.2111859013592.26E+08228381049741331395418.711.465846645244ALAlabama10730.35712180220113697019.235430.1 376240113370820966030144528206930453941652713.28.119540853855WIWisconsin551010.70805722201131253017.9148721.3 3302319903691926275.37E+0816538.376955311.2768553209.5805669345.22363314.99.316231053183DEDelaware100011222012166020.1022324.2 558321415932057977.55E+086572514414107623163713.18.827454954766NJNew Jersey340010.4388656222011118020.4415621.9 289321402745523463.1E+0817961876234411683316.212.863426655275NJNew Jersey340170.3678314012011177019.5534229 4550220152428232819661416538.376955311.2768553209.5805669345.22363311.39.16350556038NCNorth Carolina37037121201229139017.1547120.4 119145621220734822566548412329030950319.814.68162539456ILIllinois171830.699154521201131481017.0606634.4 269853712780295763.34E+0816538.376955311.2768553209.5805669345.22363311.79.317517757354WAWashington530051212012098019.6272321 1173214193090686412506373913014825.911.45107931967NCNorth Carolina3718912220110312015.6737637.3 4546201.30142179933730878516538.376955311.2768553209.5805669345.22363320.512.71642733673MIMichigan2605310220120660017.4347433.2 19448201.3612466495332.85E+0816538.376955311.2768553209.5805669345.223633126.613648467389CACalifornia60550.52573692220120934019.4689518.6 4597412.760285425453088845016538.376955311.2768553209.5805669345.22363312.16.9967041611IAIowa19025101201222109017.2458919 108275.8118.21585044254.11E+0816538.376955311.2768553209.5805669345.22363311.87.46608359441NJNew Jersey34033102201202715019.8343419.2 1455624061994558698690721045622532045492817.412.34209038209ARArkansas5055122201132559018.0621329.7 72288.4123.60428709405496170516538.376955311.2768553209.5805669345.22363318.213.52337038818MOMissouri29195122201203487017.8221531.7 207166.671.411186030008.96E+0916538.376955311.2768553209.5805669345.22363314.3911663842573PAPennsylvania420850.385320101201203447022.9159623.3 12286.837.211194484751.87E+0916538.376955311.2768553209.5805669345.22363313.67.841334468409CACalifornia6095122201203447021.3464421.4 457733099323161115861916538.376955311.2768553209.5805669345.22363311.88.3785844510KSKansas20095102201203447016.2277220.1 119142.861.2118212682187273863076529466.94.318096772129MIMichigan260930.7100360220113016.745511.2 271289.8124.201482854271.84E+08277731122751931279323.215.622936343725ALAlabama11010.481832102201138762119.0277938.8 11095.240.812470487726301104171318237068713.112.51158637607MTMontana3002710120113654117.0851225.6 45135.157.9139966048460394182723862672160018.710.43724436974IDIdaho16057122201131544117.6450129.1 5935.715.3056570240547092601782153467174911.45.126380155095MIMichigan261390.59421542220113264117.8175416.5 8631.513.51642651674934148916538.376955311.2768553209.5805669345.22363320.812.78291641894KYKentucky21151122201211340117.7142833.5 6531.513.50171163302279853316538.376955311.2768553209.5805669345.22363322.611.422000043170CACalifornia60070.476179422201212780116.9422134 68200.986.10810288618125011816538.376955311.2768553209.5805669345.22363313.86.85441847533MEMaine230090.588351102201204690118.2130420.6 4531.513.51685676516.81E+083842148395019692313.46466539491CACalifornia60330.5090734212011310624120.3383636.4 138156.166.90423535265258352916538.376955311.2768553209.5805669345.2236339.710.2974652516MTMontana30083101201205620117.7779119.9 39482.635.402294784502.66E+0816538.376955311.2768553209.5805669345.2236336.63.462524974828PAPennsylvania420170.25536290220120803019.3974110 125235.9101.1033192028538333862242795406108622.815.42874637274MTMontana3004710120113561017.801438.2 44109.246.80334818893527651116538.376955311.2768553209.5805669345.22363320.418.13322534044OHOhio39079100201201017.3787338.5 45699.442.614618992005.04E+0816538.376955311.2768553209.5805669345.22363325.817.793045046430CACalifornia60190.458755222012126020.0375343.5 248100.142.92.8612432312882.55E+0816538.376955311.2768553209.5805669345.22363319.913.820016942954MIMichigan261450.5623775222012122019.3584533.7 29994.540.52.701755518961.83E+0828852109063351345518.812.4128012243603OHOhio390350.2581525212011362019.0252531.2 235222.695.46.3601773206101.78E+081267962712385816012.16.4193124968065WAWashington530330.21465711120113429018.999818.5 45193.282.85.520635135198387245816538.376955311.2768553209.5805669345.22363314.28.41997741034WIWisconsin5506710020120144018.2448122.6 102151.264.84.320928765111.15E+08667111291638297614.310.23242842707INIndiana180771212011347018.560924.5 18387.537.52.51987863622.03E+08192199243569608510.76.853649966791NJNew Jersey340390.41061060120112427019.1296317.5 714168.772.34.82012145650331.21E+096.64.390511681708NJNew Jersey340030.34936260120112427020.910610.9 20665.828.21.8811566510911.83E+0816538.376955311.2768553209.5805669345.22363315.78.816304049120MIMichigan261470.443807702201201043019.0242724.5 80205.187.95.861266348423327478016538.376955311.2768553209.5805669345.223633127.86524947744PAPennsylvania420250.565919301201202906017.3203119.8 412126543.614675415692.1E+0916538.376955311.2768553209.5805669345.22363318.812.1116341449087OHOhio390490.25819890120121863021.4671930.9 4499.442.62.840113246209287483414147161011.26.1120236266390MIMichigan261250.16566510220113939016.0441817.3 25031.513.501638234252.15E+081958734554259108636.73.654417973733KSKansas200910.41177060120113939019.1854410.3 23821911801012182.44E+0816538.376955311.2768553209.5805669345.22363323.31444181542072OHOhio390950.18237640120120550019.3133537.3 37331.513.513464094921.16E+092884334255681187716.53.679987476380PAPennsylvania420910.2001974022011273020.8735910.1 4231.513.51417003056396021612897713316.210.74755738385OKOklahoma400191222011335015.5453226.9 3097.341.7096132061235682716538.376955311.2768553209.5805669345.22363312.28.11007849010MTMontana3000912120120016.3297220.3 75360.5154.50826624299140808041062218.14.72239855396NDNorth Dakota381050.7636612220113227016.1094712.8 62224961642146651.77E+094018114410272224144.53809154758CACalifornia6005101201131279021.2913318.5 124137.258.80652727817974047016538.376955311.2768553209.5805669345.22363314.17.65282245930PAPennsylvania4212710020121913018.1942921.7 110113.448.60667786111.19E+0816538.376955311.2768553209.5805669345.22363313.67.8115242561328MNMinnesota270531012012118018.5942621.4 394134.457.613242937713.61E+0816538.376955311.2768553209.5805669345.2236336.73.654417973733KSKansas200910.4117706012012117019.7035110.3 294108.546.502371235642.53E+0816537925433461223225.213.625942443311GAGeorgia130630.979591901201112162019.3477938.8 56045.519.504866741905.2E+08419151652080232967718.412.6981860555476CACalifornia60370.055206201201131182020.0687331 20486.837.201803666322.23E+0816538.376955311.2768553209.5805669345.22363314.89.65527452067NVNevada32510121201213029019.2235924.4 45163.169.94.66148694000487757311269105732813672316.824323142877WAWashington530770.735097421201131518017.7027439.8 414172.974.14.9413277199082.34E+0916538.376955311.2768553209.5805669345.22363311.26.1120236266390MIMichigan261250.1657755022012049021.5723117.3 4274.231.81148938141819997211031716223013.46402940368IAIowa190031012011362016.7169319.4 136311.5133.511421339141E+0916538.376955311.2768553209.5805669345.22363310.36.195320770093HIHawaii150030.203233222201207020.7228116.4 45658.7282.317808345876991416538.376955311.2768553209.5805669345.22363316.610.1707041107SDSouth Dakota460090.67920701201201039115.9868426.7 3431.513.5086755158944073138715314820711.25.41111944139NDNorth Dakota380990.500704302201131993016.006516.6 68062.326.703382614813.3E+08116162518821211881830.325.8138510834264NYNew York360050.43831920120110522019.6143856.1 45190.481.61372105434233975616538.376955311.2768553209.5805669345.22363312.38.49092844998MTMontana300290.66949982120120466017.5612420.7 19338.516.511268276011.54E+0816538.376955311.2768553209.5805669345.22363318.911.213163643256INIndiana180950.659982122201208768018.8552730.1 210207.989.101711953261.75E+0816538.376955311.2768553209.5805669345.223633206.510156448655NYNew York36109121201203150018.9795926.5 9336.415.60111520261354590716538.376955311.2768553209.5805669345.2236339.57.72081647507IAIowa190270.7645730120121174016.4215917.2 4573.531.509568165954464616538.376955311.2768553209.5805669345.22363314.911.81388641450ILIllinois17061100201201685016.0714926.7 89363.727.319292395261.3E+095868132571105583193921.313.590339343541INIndiana180970.213757902201132082020.9879434.8 68298.2127.81156329846.33E+08336718858189817.416.31959330211MSMississippi2814110020113864020.2659133.7 751006.6431.428.761632610004.51E+0938451837955339428.71934382937468LALouisiana220710.278863302201134284022.2303547.7 5175.632.42.161483864299525755216538.376955311.2768553209.5805669345.22363313.27.32609745273MNMinnesota27095102201203730018.372120.5 4524.510.50.70543128056775869116538.376955311.2768553209.5805669345.22363315.810.52574842162OROregon4106112120121551018.0314626.3 23737115910.611230902591.97E+082185265403833795323.111.64735139080MSMississippi2807112220113384019.0964534.7 453361449.61234862331.42E+0816538.376955311.2768553209.5805669345.22363318.911.213163643256INIndiana180950.659982122201212910018.7710130.1 116113.448.63.240792149015270768416538.376955311.2768553209.5805669345.22363314.810.48164237130PAPennsylvania420330.52942222220120686017.7802725.2 4558.825.20957600012292554113735296525135.72841753263TXTexas4801510120113475016.324518.7 25878.433.612887920195.35E+0817353829749081548713.86.929963056447COColorado80690.5898404212011371020.097120.7 16125210813191660003.98E+0816538.376955311.2768553209.5805669345.22363321.410.317278042632INIndiana181570.462206022012016019.8020131.7 28760225811057983729499713316538.376955311.2768553209.5805669345.22363310.75.810793156468NYNew York360690.35662530220120353018.3693616.5 19412466495332.56E+0817063220431847716126.613648467389CACalifornia60550.52573692220113296019.358718.6 4501689794520945913690392483821710.64311440818MIMichigan261510.415232022011313016.8574527.6 411289217423780340916556853392421.518.35084536966TXTexas48073122201132545017.4479139.8 25412316190001.84E+0916538.376955311.2768553209.5805669345.2236338.94.843799464618VAVirginia518100.512217502201202558021.3342313.7 779115986290002.28E+097064419274114783989226.116.7182058442241MIMichigan261630.15848041220113101021.5489142.8 37611810840001.98E+0816538.376955311.2768553209.5805669345.22363373.4133953293613NYNew York360590.179097612201201034019.1032410.4 451392899435261041916538.376955311.2768553209.5805669345.22363310.25.92419949536NDNorth Dakota3808910220122239017.7784316.1 10006077018664127866406421071085316631.826.67149231335NMNew Mexico3503112220113592017.9763958.4 890186141422422010516538.376955311.2768553209.5805669345.22363321.816.44603931912WVWest Virginia5401912120120017.0026938.2 450152443151943802816538.376955311.2768553209.5805669345.22363316.811.81276137706MOMissouri29115100201203210016.7827428.6 22311412699571.53E+0816538.376955311.2768553209.5805669345.22363318.812.4128012243603OHOhio390350.25815252120122109018.8465231.2 1181611428675192593616538.376955311.2768553209.5805669345.22363311.7811392451705ILIllinois170990.57246390220122108017.7653319.7 4501299891417017948234928350681813.97.21093942364NENebraska3104110220113938016.6497821.1 33712585950003.37E+0816538.376955311.2768553209.5805669345.22363314.18.714754646226ILIllinois171610.64643180220120788019.6343822.8 1121223861862946890116538.376955311.2768553209.5805669345.22363397.6913944278NENebraska31039102201221911017.1988516.6 1311976362938614949212156500246350187.7510869271364NJNew Jersey340410.509873821201111911018.271612.7 1520134571350003.71E+0918136570426282809764418.414.5158587364971NYNew York360610.13922970120110167022.0334732.9 20701042155881.34E+081132580462424887917.410.137577051310AZArizona40210.54538430120113396018.7132327.5 830294088213080812216538.376955311.2768553209.5805669345.22363314.591111339339MIMichigan26097102201203777017.2432923.5 15611685116523.24E+0816538.376955311.2768553209.5805669345.22363313.86.929963056447COColorado806912120120822019.595620.7 45137210543434775611995978467149912.38.49092844998MTMontana300290.66949982120113742017.5877620.7 41402960369204.12E+0816538.376955311.2768553209.5805669345.22363316.612.520608643253NCNorth Carolina3707110120120479019.8372229.1 4512038488423274737176418736856711.89.21030242286IAIowa19063101201131025016.9628821 797110741860002.08E+09500001021088482778818.812.4128012243603OHOhio390350.258152521201134480021.4576231.2 14211545617742.3E+0816538.376955311.2768553209.5805669345.22363318.310.219755947258INIndiana180390.55722622220120669019.2519628.5 60075040938733050109426901001298.55.7289052529MTMontana3002510120113427015.9826314.2 25901780473791.84E+081477344423192944814.3911663842573PAPennsylvania420850.38532010120110495019.0320823.3 16113191660003.17E+081840019493721943221.410.317278042632INIndiana181570.46220601201132621119.574331.7 17811330097161.52E+08200902107461598586.7497177793373MDMaryland240310.20032830220111728118.8376510.7 1500896671289369495716538.376955311.2768553209.5805669345.22363318.812.211194442303NYNew York360890.422537222201227583118.3555531 14301329248491.87E+0816538.376955311.2768553209.5805669345.22363310.85.86339550238MTMontana300490.892215501201212321119.044816.6 1990843640008758897816017152724914879148.58002648415NYNew York36011122201101464118.2881722.5 1350781811099423755616538.376955311.2768553209.5805669345.22363318.212.88040638567ALAlabama1043122201201074118.3613331 33911803847252.04E+082008918913904989816.812.46970937527OHOhio3908112220111393119.1328629.2 144130732000371724072599271776144019.712.4622232262VAVirginia51515102201102165117.4310832.1 7608143320845873944020518411.12.51366547689NENebraska311850.72432760220113436115.9507113.6 14801835907691.85E+081639953594020914815.98.27245348674WAWashington53007122201133768119.0381224.1 4601154372811651183384141340662419.612.413614642568MIMichigan260250.887698322201133280116.2709232 69073445769820994762661433919231213.110.25313944542OHOhio39005121201132640118.2234423.3 421433098256131262616538.376955311.2768553209.5805669345.22363318.611.735067046749NCNorth Carolina370670.465353301201201291117.931530.3 28912736519843.36E+09328731400470201738611.14.870346278948ILIllinois170970.513087612201137663121.9335915.9 41511500273732E+08274376769547112906158.191654245258FLFlorida121030.21135301201101491119.1112923.1 4512538341354231357350565583903149.126928251941ILIllinois171190.43144130120113556117.8087723.1 7011547999361.38E+0816538.376955311.2768553209.5805669345.22363314.85.17001951456WIWisconsin5509712120120498118.7389219.9 31811867330002.19E+0816538.376955311.2768553209.5805669345.22363317.811.9519467553942ILIllinois170310.045975602201206172119.2028829.7 15001499612002.01E+08743327661893728811.45.126380155095MIMichigan261390.594215422201131196119.1203216.5 27612106089118.72E+0916538.376955311.2768553209.5805669345.22363315.48.642389560078CACalifornia60830.42950692220122418122.8887624 216195565133759833216538.376955311.2768553209.5805669345.22363320.413.54444243394MNMinnesota27007122201211973115.8434433.9 1251323005323117543116538.376955311.2768553209.5805669345.22363321.115.93149936750KYKentucky2117712220120949117.2551437 56917100060008.25E+0848063702788682827710.86.343497257494PAPennsylvania421330.5245041212011046120.5308617.1 9716644541684210588332551987351538.96.158537579845TXTexas481570.3938496012011352118.2488315 26412439277882.68E+08234091060642011102716.411.78883044502NYNew York360150.63441212220112976119.4053428.1 24111064598221.17E+0816538.376955311.2768553209.5805669345.2236335.73.844873476258NJNew Jersey340050.376785421201223462118.581099.5 12011337172993.62E+09736427932064559214.910.37545543874WAWashington5304112120113497122.0092825.2 22901401119321.31E+0816538.376955311.2768553209.5805669345.22363312.810.46451141431KSKansas20155122201201678118.690223.2 770586993737092561016538.376955311.2768553209.5805669345.2236339.95.84594952018OHOhio390111212012078118.0771415.7 34012988437305.71E+08287961702750071576414.69.451711051878NENebraska310550.18229130120113907120.1634124 451289370002703457116538.376955311.2768553209.5805669345.22363312.910.85229345177MIMichigan26027101201201440117.1126323.7 940348436103304698316538.376955311.2768553209.5805669345.2236331710.64311440818MIMichigan261510.41523202201201946117.3134427.6 10304273744552459076425510501017207015.711.64198140338PAPennsylvania42117100201101117.7755427.3 29313738057788234224716538.376955311.2768553209.5805669345.22363318.212.268530654341CACalifornia60770.411159112201201387118.2263930.4 750889132181.02E+083121511838182710.868875952571WIWisconsin550270.368864521201132781118.4416616.8 57315643325801.22E+0916538.376955311.2768553209.5805669345.22363326.116.7182058442241MIMichigan261630.15848041220121159120.9182142.8 18011171662291.41E+0816538.376955311.2768553209.5805669345.22363310.36.195320770093HIHawaii150030.20323322220120159118.7636716.4 1421767426397686577516538.376955311.2768553209.5805669345.223633105.894911379619NYNew York361190.148744301201201118.1575715.8 21612148988301.63E+091288167333204159826.83.41081726105416VAVirginia510590.4954929012011113616121.2106910.2 45140263057274804962503367665159914.18.82042845066MNMinnesota27057102201131387117.1289922.9 75017752830008.4E+0816538.376955311.2768553209.5805669345.22363327.920152600636251PAPennsylvania421010.119400202201215653120.548947.9 55060870851579490734012184783125517.29.92162341665WAWashington5300310220113852117.8750727.1 75017752830008.25E+0827138890941812615427.920152600636251PAPennsylvania421010.10478780220110466020.5305347.9 1241905940001.1E+0816538.376955311.2768553209.5805669345.2236339.65.380502963959MDMaryland240050.13513810220122220018.514914.9 450672585317360255029411037821154318.6145222836647MEMaine230251022011040018.1141932.6 451166160901668523316538.376955311.2768553209.5805669345.2236331711.66996742314OKOklahoma400371212012114016.6300428.6 8301049017141.36E+0870404291845442110.68.711842859370CTConnecticut90150.501046321201102151018.72919.3 3019164899926872116538.376955311.2768553209.5805669345.22363314.29.53841356729TNTennessee47047101201205671016.0421623.7 32601498963512.08E+0818721137653435843518.912.219276843758LALouisiana220190.525226312201131123019.1540331.1 54513607120304.08E+08343131142959802239514.49.614367939574PAPennsylvania420210.8479581222011083019.8270124 9315943576675494506343855790442838.24.878234180504TXTexas480850.393268201201138764118.1395713 450362136493713739628125961590715.16.41181733734MIMichigan26071102201134259117.4301421.5 98074448919895365545345637127436506.33.713188764434WIWisconsin551310.53338702201132010118.3101610 45013582967264.68E+0816538.376955311.2768553209.5805669345.22363315.510.717970342396INIndiana181630.49468902201209853119.9647726.2 16811202339322.75E+081897025774264150458.73.410656782216GAGeorgia13113101201101776119.4312512.1 4501069294898067371031191233414209.42235337551ARArkansas50830.587701201201132995116.0985829.4 2361560340026580948216538.376955311.2768553209.5805669345.22363311.8714232462348GAGeorgia1322310120120314118.0022718.8 39713285104444402021616538.376955311.2768553209.5805669345.22363319.413.7409245951444TXTexas482010.133454201201221093117.6001633.1 450545201558047406418851575562175217.7117588945861OROregon410590.52462780020113480118.2034528.7 450358136253866122316538.376955311.2768553209.5805669345.22363313.35.3972647055MNMinnesota27149102201201332117.4703518.6 10201084684221.23E+08657322221668328011.46.712314357809NHNew Hampshire330170.531676502201101641118.6238918.1 85110916648116907698362011916724.517.4912935808SDSouth Dakota460230.59028120120113636116.2743141.9 26912705075183.04E+0812170188726631057919.411.373533449618OROregon410510.27525470020113866119.5307830.7 560536914856805448516538.376955311.2768553209.5805669345.22363312.27.16197650390WIWisconsin551110.52408672220120102118.0358219.3 450610204598159728916538.376955311.2768553209.5805669345.22363311.45.18911853075NHNew Hampshire330090.373630121201212147118.2173116.5 1391889533591.05E+0816538.376955311.2768553209.5805669345.22363310.26.59365348573IAIowa1906112220122349118.4692616.7 56004866741905.55E+0816538.376955311.2768553209.5805669345.22363318.412.6981860555476CACalifornia60370.05821520120120347120.1341731 66618451447249.67E+08480953202793842934717.511.227517441059MOMissouri290770.502852301201138471120.6901628.7 51503491650004.89E+0816538.376955311.2768553209.5805669345.22363313.28.951365760976NJNew Jersey340070.3634137012012010500120.0079622.1 33301845455702.31E+0829729394158991273219.814.818988541331GAGeorgia132150.362713202201109429119.2571134.6 32002913700003.1E+0816538.376955311.2768553209.5805669345.22363313.96.96570751619NYNew York3611312120120119.5518820.8 19611624010001.51E+0816538.376955311.2768553209.5805669345.22363327.920152600636251PAPennsylvania421010.11940020220120490018.8343647.9 1620540595687068691716538.376955311.2768553209.5805669345.22363326.623.15090233716ARArkansas5035121201211208018.0737749.7 4503034317831187260283214857781911.7811392451705ILIllinois170990.57246390220113762017.2555219.7 370124220051306335616538.376955311.2768553209.5805669345.22363310.59.31086646765MNMinnesota2707510220120585016.3853219.8 26912780295762.96E+08190261075743491296711.79.317517757354WAWashington5300512120113784019.5066721 1921570786836585243416538.376955311.2768553209.5805669345.22363315.712.17040038320OHOhio390130.58629632020120379018.0029327.8 17611101225931.18E+081259151772822761117.49.449459344400FLFlorida121270.342217621201108423018.582526.8 1551460222354955086216538.376955311.2768553209.5805669345.2236338.24.63665158544MNMinnesota270850.56543442220120117017.7185112.8 731316679663140595516538.376955311.2768553209.5805669345.22363311.45.77622761107KSKansas20103101201202850017.2625117.1 39312162432424.25E+0916538.376955311.2768553209.5805669345.22363317.410381711755054AZArizona40130.08719671120120541022.1708127.4 40192677881005525616842622932010.46.8528937179NDNorth Dakota3802110220113177016.1236117.2 4516120671718128815871111914610.49.5642940227NDNorth Dakota3800910220113136015.7869919.9 36614205419614.82E+0834685919879371779014.57.728540750849NENebraska311090.49175042220113456019.9928322.2 3616088060855990316538.376955311.2768553209.5805669345.22363319.712.3702739851MTMontana30077101201201184015.962632 2420101291918944120851339129542183596619.812.313490540639NYNew York360130.53503082120110596018.3631832.1 13911443048451.01E+091728336503198649112.6751526967767ILIllinois170890.21559070220113441020.729319.6 650292641653081428416538.376955311.2768553209.5805669345.22363314.69.312708942363PAPennsylvania420130.674863122201203017.2434923.9 88143388922295218943236317806176515.78.816304049120MIMichigan261470.4438077022011321017.2006424.5 1141.3411371550021.82E+081179532532688578715.97.710516054002ILIllinois170371022011348019.0218223.6 4861913783093417.89E+08352733447374432906418.512.429761943573FLFlorida120330.523350721201101932020.4856630.9 1629.5811110090001.54E+0974772718179488024.31.928546599198COColorado803510120113372021.154556.2 1241.21979329921.45E+0816538.376955311.2768553209.5805669345.22363317.112.23943738974ILIllinois1712112120120989018.7913729.3 3423.2202033046342.28E+0816538.376955311.2768553209.5805669345.2236338.95.218386256878PAPennsylvania4201910220120248019.2440314.1 1707.1201800557921.94E+082675848175041120299.4586342071260MDMaryland240330.4203829012011250019.0807214.4 1024.76012503354219478643774988233526.915.81042537451MTMontana300850.442933801201131940116.9041842.7 2332.1402496418293.13E+0816538.376955311.2768553209.5805669345.22363314.38.616642654430WIWisconsin550590.542803902201208422119.5610522.9 6671.117687285611.05E+097221742480129953458211.66.790099363770NCNorth Carolina371830.50069940220110240120.7697218.3 923.040560549384130628816538.376955311.2768553209.5805669345.22363311.97.17344253345NYNew York360530.5481572120120121117.5365319 451249014883297060516538.376955311.2768553209.5805669345.22363313.28.41024653225UTUtah49023121201205870117.3111321.6 66051843345239305490109210719.27.3239439500NDNorth Dakota38037102201131697115.471726.5 61904403512874.29E+0840966523589702317311.96.799895457561MOMissouri291890.194117101201133037119.8760818.6 33212626390243.27E+083836430477174211015.73.844873476258NJNew Jersey340050.37678542120111394119.606579.5 24713009495653.22E+0816538.376955311.2768553209.5805669345.22363317.19.87567444479MOMissouri290310.500103401201202578119.5912526.9 451363950004518456116538.376955311.2768553209.5805669345.22363316.68.75674542573OHOhio391470.65733792220121762117.6262725.3 60075040931197322716538.376955311.2768553209.5805669345.2236338.55.7289052529MTMontana30025101201213489116.2981814.2 511297581953199669516538.376955311.2768553209.5805669345.22363316.810.4180903455306TXTexas484390.18567850120120436117.2811427.2 1740352393564078557116538.376955311.2768553209.5805669345.22363311.12.51366547689NENebraska311850.72432760220121503117.5238413.6 991332150087.35E+0853438581265383520.618.85742431173TNTennessee4701912220113533120.4152239.4 1061637369076076948416538.376955311.2768553209.5805669345.2236332510.22336836191VAVirginia511471022012073017.922635.2 44511090999338925055516538.376955311.2768553209.5805669345.22363312.99.521646945964NYNew York360630.5061712012012010018.3069622.4 33214707620005.12E+0867901136298761796973.4133953293613NYNew York360590.1361992122011010020.0542610.4 26211967090002.03E+0829597128955701456911.17.436651371217NJNew Jersey340210.21793332120110132019.1296318.5 14201940772902.17E+08108092694702222.415.772202350597MAMassachusetts250250.36213060220111515019.1943538.1 16511047169575.22E+081245628002487600014.27.254337649523FLFlorida120090.40454772120110273020.0737921.4 216177197018932425246226104611192249136.91950441867SDSouth Dakota4603512120113682018.3507119.9 14011959853219115730151016437869221.317.42521336109GAGeorgia13147100201104560016.7660238.7 1121971715542.1E+0916538.376955311.2768553209.5805669345.22363318.812.1116341449087OHOhio390490.2581989012012237021.4671930.9 7808288988789022485861843320233054136.25145455487MDMaryland24047122201101075018.304419.2 730480533865124972013.79.17774239194PAPennsylvania421110.41459462220112471017.7522222.8 10601165462221.4E+08113281118233864506.33.46520383877VAVirginia5106110120112421018.755279.700001 1511768640708988246871877751610459718.711.967415846252MOMissouri290950.362087101201131676018.3140130.6 35513711913635.43E+0822221284449501638485.114424864090MNMinnesota271090.5195369022011346020.1123113.1 24402453568582.77E+08206363105516810923106.87375050612VAVirginia510151222011062019.4392616.8 14101755561872.13E+081645039613996782511.66.979855264152MAMassachusetts250270.3769342212011048019.1748818.5