statistics

profilekorokiabe
MURDERRATE.xlsx
Home>Mathematics homework help>Statistics homework help>statistics

MURDER RATE

State Population Murders GunMurders GunOwnership Murder Rate (per 100,000) Poverty rate by house hold income Undergrad Per capita Income
Alabama 4779736 199 135 0.517 4.163409862 19.2 22 35913
Alaska 710231 31 19 0.578 4.3647770936 11.4 26.6 69564
Arizona 6392017 352 232 0.311 5.5068689586 18.2 25.6 37935
Arkansas 2915918 130 93 0.553 4.4582872358 18.7 18.9 34671
California 37253956 1811 1257 0.213 4.8612286974 16.4 29.9 51871
Colorado 5029196 117 65 0.347 2.3264155941 12.1 35.6 49254
Connecticut 3574097 131 97 0.167 3.6652614632 10.8 35.6 64906
Delaware 897934 48 38 0.255 5.3456044654 13 28.7 62937
District of Columbia 601723 131 99 0.036 21.7708148101 18.4 48.5 168030
Florida 19687653 987 669 0.245 5.0132943729 16.6 25.3 38504
Georgia 9920000 527 376 0.403 5.3125 18.4 27.5 42029
Hawaii 1360301 24 7 0.067 1.7643153978 11.5 29.6 49418
Idaho 1567582 21 12 0.553 1.3396428385 14.8 23.9 34620
Illinois 12830632 453 364 0.202 3.530613301 14.3 30.6 50304
Indiana 6483802 198 142 0.391 3.0537638256 15.2 22.5 42996
Iowa 3046355 38 21 0.429 1.2473923755 12.3 25.1 45884
Kansas 2853118 100 63 0.421 3.5049374053 13.5 29.5 44243
Kentucky 4339367 180 116 0.477 4.1480704444 19 21 37579
Louisiana 4533372 437 351 0.441 9.639623662 19.9 21.4 48599
Maine 1328361 24 11 0.405 1.8067377769 14 26.9 38352
Maryland 5773552 424 293 0.213 7.3438327047 10.4 37.3 53675
Massachusetts 6547629 209 118 0.126 3.1919951482 11.7 38.2 60808
Michigan 9883640 558 413 0.384 5.6456932871 16.2 24.6 38763
Minnesota 5303925 91 53 0.417 1.7157105351 11.4 31.5 50148
Mississippi 2967297 165 120 0.553 5.560616278 21.9 19.6 31688
Missouri 5988927 419 321 0.417 6.9962449033 15.5 25.2 42204
Montana 989415 21 12 0.577 2.1224663058 15.2 27.4 37733
Nebraska 1826341 51 32 0.386 2.7924686573 12.3 27.4 49569
Nevada 2700551 158 84 0.338 5.8506578843 15.4 21.8 44589
New Hampshire 1316470 13 5 0.3 0.9874892705 9.2 32 48388
New Jersey 8791894 363 246 0.123 4.1288031908 11.1 34.5 55023
New Mexico 2059179 118 67 0.348 5.7304391702 20.6 25.3 40297
New York 19378102 860 517 0.18 4.4379991394 15.9 32.4 61267
North Carolina 9535483 445 286 0.413 4.6667798579 17.2 26.5 43141
North Dakota 672591 9 4 0.507 1.3381088953 11.1 25.8 52185
Ohio 11536504 460 310 0.324 3.9873431327 15.8 24.1 42667
Oklahoma 3751351 188 111 0.429 5.0115278469 16.6 22.7 38303
Oregon 3831074 78 36 0.398 2.0359825991 16.4 29.2 49601
Pennsylvania 12702379 646 457 0.347 5.0856615127 13.6 26.4 46387
Rhode Island 1052567 29 16 0.128 2.7551690296 14.8 30.5 46332
South Carolina 4625364 280 207 0.423 6.0535776211 17.2 24.3 35126
South Dakota 814180 14 8 0.566 1.7195214817 14.1 25.1 45605
Tennessee 6346105 356 219 0.439 5.6097401477 18.2 23 39370
Texas 25145561 1246 805 0.359 4.9551489426 17.2 25.5 47417
Utah 2763885 52 22 0.439 1.8814096824 11.8 28.5 41500
Vermont 625741 7 2 0.42 1.1186737005 12.2 33.1 42170
Virginia 8001024 369 250 0.351 4.6119096756 11.8 34 51946
Washington 6724540 151 93 0.331 2.2455067559 13.2 31 52679
West Virginia 1852994 55 27 0.554 2.9681693519 18.3 17.3 35368
Wisconsin 5686986 151 97 0.444 2.6551850136 13.2 25.7 44126
Wyoming 563626 8 5 0.597 1.419380937 10.6 23.8 64603

Sheet1