Download the "State Crime" Excel sheet; row 2 gives detailed descriptions of each variable, while row 4 gives short versions that should be used in your regressions. Estimate the following multiple regression models (remember that all of your independent variables will have to be in adjacent columns in Excel). Look at each set of results critically and consider how you would interpret the strengths and weaknesses of each model. Save your results from each model for use when completing the end-of-module assessment. Use "PropCrime" as your dependent variable in each model. The notation f(X, Y, Z) means "a function of X, Y, Z; i.e., X, Y, and Z are your independent variables. Even though it isn't listed, each model will include an intercept. NOTE: when Excel reports a value like 2.4E-06, this is scientific notation for 2.4 * (10^-6), or 0.0000024.
Model A: PropCrime = f(PerCapIncome, %SameHouse, %young)
Model B: PropCrime = f(Robbery, %Unemploy, MedianAge)
Model C: PropCrime = f(Robbery, %Unemploy, MedAgeMale)
Model D: PropCrime = f(Robbery, %Unemploy, MedAgeFemale)
Model E: PropCrime = f(%Metro, %Bachelors+, %Poverty, Temp)
Model F: PropCrime = f(%Metro, %Bachelors+, %Poverty, Sun)
Model G: PropCrime = f(%Metro, %Bachelors+, %Poverty, Rain)
The state of East Maryland currently has a property crime rate of 1,896.8, a 91.4% metro rate (be sure to use 91.4% or 0.914, not 91.4; be careful of the units on all the variables), a "%Bachelors+" rate of 38.6%, a poverty rate of 9.6, and about 112 sunny days per year. Recent economic changes have led to the poverty rate declining to 9.1. This change will likely be associated with the PropCrime rate changing from about 1896.8 property crimes (per 100,000 inhabitants) to about ___ property crimes.
State Crime - Excel X AutoSave O Off) Search Pete Stibbs PS Insert Page Layout Formulas Data Review View Help Share Comments File Home B36 X V 284.6 B E F G H J K L M N P Q R S T U V W X Y A C 1 Table 5, Crime in the United States by State, 2019, Rate per 100,000 inhabitants Non-crime variables; units are as specified in row 2 descriptors Violenvated nonnegligen Motor t assaul Robber Property Burglar Larcen vehicle Total state 2 crime t manslaughte y crime y y-theft theft population Per capita % of state po % 25 ye unemploymenteras # of avera % living Median age Median age, M Median age % 18-24/18 % male 18-24 https://ucr.fbi.gov/crime-in-the-u.s/2019/crime-in-the-u.s.-2019/downloads/download-printable-files toyoungmale 4 State Violenseau Murder Robber PropCrime Burglar Larcen Car Thef Population PerCapIn %Metro %%Bache Unemploy %Pover Temp Sun Rain %SameH MedianAge MedAgeMale MedAgeFe young 24 MICHIGAN 437.4 305.9 3.6 53.6 1,585.0 286.1 1,121.3 177. 9.986,857 43787 82.0% 30.0% 4.1 12.9 44.4 71 33 86.2 39.7 38.1 40.9 16.5% 16.9% 25 MINNESOTA 236.4 135.1 2.1 55.8 2,078.8 282.4 1,597.5 198.9 5,639,632 51079 77.9% 37.3% 3.2 8.9 41.2 95 27 85.9 38 36.6 38.7 15.0% 15.2% 277.9 184.6 11.2 57.1 2,375.8 627.0 1,555.7 193.1 2,976,149 35791 48.4% 22.3% 5.5 19.5 63.4 111 86.9 37.5 35 37.9 17.1% 17.7% 26 MISSISSIPPI 495.0 357.4 9.3 80.8 2,638.7 430.4 1,865.0 343.3 6,137,428 43529 75.1% 30.2% 3.3 12.9 54.5 115 42 84.8 38.6 36.7 39.6 16.0% 16.4% 27 MISSOURI 28 MONTANA 404.9 324.9 2.5 19.2 2,193.2 270.1 1,700.6 222.4 1,068,778 44457 35.8% 33.6% 3.6 12.6 42.7 82 15 84.1 39.9 38.7 41.1 15.9% 16.5% 300.9 192.9 2.3 40.9 2,039.3 245.3 1,536.3 257.7 1,934,408 49082 65.4% 33.2% 3 24 16.8% 29 NEBRASKA 9.9 48.8 117 84.1 36.5 35.1 37.4 16.5% 30 NEVADA 493.8 312.3 4.6 106.7 2,322.1 503.5 1,453.0 365.6 3,080,156 45956 90.9% 25.7% 3.9 12.7 49.9 158 9 82.1 38 36.7 37.9 14.5% 14.6% 31 NEW HAMPSHIRE 152.5 83.7 2.4 23.0 1,209.2 126.3 1,017.3 65.7 1,359,711 56978 63.1% 37.6% 2.6 7.5 43.8 9 43 86.1 42.9 41.4 43.3 15.1% 15.4% 2.9 64.5 1,335.7 184.6 1,034.7 116.4 8,882,190 61023 100.0% 41.2% 3.4 9.1 52.7 94 47 89.8 39.9 37.8 41 206.9 122.2 14.3% 14.9% 32 NEW JERSEY 17.1% 33 NEW MEXICO 832.2 650.5 8.6 111.6 3,112.7 696.8 1,988.8 427.2 2,096,829 39441 67.3% 27.7% 17.5 53.4 167 15 86.7 37.8 35.5 38.4 16.5% 34 NEW YORK 358.6 229.0 2.9 92.9 1,373.3 141.9 1,166.1 65.3 19,453,561 60329 93.0% 37.8% 3.8 13.1 45.4 63 42 89.5 38.8 36.6 39.8 15.8% 16.3% 35 NORTH CAROLINA 371.8 262.4 6.0 72.5 2,357.3 519.1 1,666.0 172.2 10,488.084 42513 81.1% 32.3% 3.8 13.6 59 109 50 84.8 38.7 36.6 39.5 15.9% 16.8% 36 NORTH DAKOTA 284.6 200.6 3.1 23.5 1,977.0 342.2 1,399.6 235.2 762,062 51669 50.2% 30.4% 2.3 10.5 40.4 93 18 82.2 35.1 34.2 36.7 19.8% 20.3% 37 OHIO 293.2 163.9 4.6 75.7 2,055.7 375.5 1,520.4 159.7 11,689,100 44838 80.3% 29.3% 4.2 13 50.7 72 39 85.3 39.4 37.7 40.7 15.6% 16.0% 38 OKLAHOMA 431.8 307.9 6.7 59.9 2,845.3 671.7 1,835.5 338.1 3,956,971 42991 66.6% 26.2% 3.1 15.1 59.6 139 37 83.2 36.6 34.9 37.5 16.7% 17.1% 39.3 37.9 40.1 14.8% 15.1% 39 OREGON 284.4 185.5 2.8 54.0 2,730.6 349.1 2,021.5 360.0 4,217,737 46386 84.0% 34.5% 3.7 11.5 27 82.9 40 PENNSYLVANIA 306.4 191.1 5.2 76.1 1,403.4 182.4 1,124.2 96.8 12,801,989 51473 88.7% 32.3% 4.5 2 48.8 87 43 87.6 40.8 38.9 42.1 15.8% 16.1% 41 RHODE ISLAND 221.1 132.9 2.4 39.5 1,534.8 219.1 1,187.5 128.2 1,059,361 50081 100.0% 34.8% 3.6 11.6 50.1 98 48 87.4 39.9 38.1 41.6 17.5% 17.8% 42 SOUTH CAROLINA 511.3 390.5 9.0 64.0 2.940.3 533.4 2,116.1 290.8 5,148,714 40874 85.7% 29.6% 2.8 13.9 62.4 115 50 85.7 39.4 37 40.1 16.4% 17.2% 399.0 302.5 1.9 22.0 1,771.0 299.1 1,273.4 198.5 884,659 49462 48.1% 29.7% 3 11.9 45.2 104 20 84.2 37 35.6 37.9 16.6% 16.9% 43 SOUTH DAKOTA 44 TENNESSEE 595.2 456.7 7.3 90.1 2,652.6 437.4 1,934.4 280.9 6,829,174 44724 78.3% 28.7% 3.4 13.8 57.6 102 85.5 38.7 37.1 39.8 15.5% 16.0% 4.9 100.0 2,390.7 392.8 1,730.6 267.2 28,995,881 47705 89.3% 30.8% 3.5 13.6 64.8 135 84.4 34.6 33.1 35 418.9 263.0 16.5% 17.0% 45 TEXAS 46 UTAH 235.6 141.4 2.2 35.1 2,169.3 276.7 1,682.4 210.2 3,205,958 43533 89.6% 34.8% 2.5 8.8 48.6 125 12 83.1 30.8 29.6 30.6 19.4% 19.4% 42.9 41.1 43.5 16.7% 17.4% 47 VERMONT 202.2 144.6 1.8 11.4 1,424.4 204.3 1,172.3 47.8 623,989 49507 35.5% 38.7% 2.3 10.1 42.9 58 43 86.7 48 VIRGINIA 208.0 128.7 5.0 41.3 1,642.7 162.8 1,359.5 120.3 8,535,519 52015 87.7% 39.6% 2.7 9.9 55.1 100 44 84.7 38.2 36.4 39 15.5% 16.1% 49 WASHINGTON 293.9 179.9 2.6 67.6 2,681.9 453.6 1,907.9 320.5 7,614,893 58077 89.8% 37.0% 4.1 9.8 48.3 5 38 82.3 37.7 36.5 38.6 15.0% 15.5% 15.49% 50 WEST VIRGINIA 316.6 249.1 4.4 21.1 1,583.4 328.7 1,119.7 135.0 1,792,147 38399 64.5% 21.1% 4.9 16.2 51.8 60 45 88.3 42.5 40.5 43 15.0% 51 WISCONSIN 293.2 200.0 3.0 51.4 1,471.4 217.6 1,127.0 126.8 5,822,434 47264 74.7% 31.3% 3.3 10.4 43.1 89 33 86.0 39.5 37.8 40.1 15.7% 15.9% 217.4 147.6 2.2 11.6 1,571.1 241.2 1,206.7 123.2 578,759 55858 31.0% 29.1% 3.7 9.9 42 114 13 83.2 37.7 36.1 37.6 16.0% 52 WYOMING 16.4 - Sheet1 + + 73% Ready 8:04 AM Type here to search O BOR A PDF W 7/16/2021X State Crime - Excel Pete Stibbs PS AutoSave O Off) Search Share Comments File Home Insert Page Layout Formulas Data Review View Help B36 X V 284.6 J K L M N O P Q R S T U V W X Y Z A D E F G H 1 Table 5, Crime in the y State, 2019, Rate per 100,000 inhabitants Non-crime variables; units are as specified in row 2 descriptors nonnegligen Motor Robber Property Burglar Larcen vehicle Total state 2 manslaughte y crime V y-theft theft population Per capita % of state po % 25 ye unemploymentera # of avera % living Median age Median age, M Median age % 18-24/18 % male 18-24 % female 18-2 i https://ucr.fbi.gov/crir19/crime-in-the-u.s.-2019/downloads/download-printable-files %%Bache %%Unemploy %Pover Temp Sun Rain %SameH MedianAge MedAgeMale MedAgeFe %young %oyoungmale %youngfemale 4 State Murder Robber PropCrime Burglar Larcen Car Thef Population PerCapIn %Metro 86.3 39 36.9 39.8 16.2% 15.8% 5 ALABAMA 15.6 62.8 99 58 16.7% 1.3 80.4 2,674.4 531.9 1,886.1 256.5 4,903,185 39956 76.1% 26.3% 3 35.5 38.1 17.3% 16.1% 6 ARIZONA 5.0 89.1 2,440.5 394.3 1,796.9 249.4 7,278,717 41266 95.2% 30.2% 4.9 13.5 60.3 193 14 82.6 37.7 16.7% 40278 63.4% 23.3% 3.5 16 60.4 123 51 84.6 38.1 36.3 39 16.2% 16.6% 15.8% ANSAS 8.0 51.6 2,858.0 599.6 2,012.6 245.9 3,017,804 132.4 2.331.2 386.1 1,586.3 358.8 9,512,223 57497 97.9% 35.0% 4.2 11.8 59.4 146 22 87.1 36.5 34.6 37 16.4% 16.9% 16.0% 8 CALIFORNIA 4.3 384.0 5,758,736 53704 87.6% 42.7% 2.7 9.4 45.1 136 16 82.0 367 35.5 37.5 15.0% 15.5% 14.6% 9 COLORADO 3.8 63.6 2,590.7 348.4 1,858.3 3.6 9.9 49 82 50 87.9 41 38.8 42.1 15.3% 16.0% 14.6% 10 CONNECTICUT 2.9 54.1 1,426.6 180.7 1,078.7 167 .3 3,565,287 65906 83.2% 39.8% 41 15.6% 1 DELAWARE 4.9 81.1 2,252.2 304.8 1,782.7 164.7 973,764 47978 100.0% 33.2% 3.7 11.2 55.3 97 46 87.4 40.6 37.9 16.0% 16.5% 295.2 1,668.7 181.8 21,477,737 46339 96.8% 30.7% 3.3 12.7 70.7 101 55 84.5 42 40 42.9 12 FLORIDA 75.5 2,145.7 15.0% 15.6% 14.5% 5.2 13 GEORGIA 6.2 75.0 2,375.8 372.1 1,779.8 223.9 10,617,423 42863 83.1% 32.5% 3.5 13.5 63.5 112 51 84.9 36.7 34.7 37.3 16.0% 16.7% 15.4% 14 IDAHO 2.0 8.7 1,219.5 219.7 911.8 87.9 1,787,065 41632 74.3% 28.7% 2.8 11 44.4 120 19 82.8 36.4 34.6 36.2 16.3% 16.6% 16.0% 98.4 1,846.5 271.7 1,426.6 148.2 12,671,821 51706 38.8% 35.8% 4 11.4 51.8 95 39 87.3 38.1 35.9 38.6 15.5% 15.9% 15.0% 15 ILLINOIS 6.6 5.6 79.2 1,971.0 323.7 1,443.4 203.8 6,732,219 43960 78.2% 26.9% 3.2 11.9 51.7 88 42 85.3 37.7 36 38.6 16.5% 16.9% 16.1% 16 INDIANA 38.2 36.6 39.4 17.0% 17.4% 16.7% 17 IOWA 1.9 27.4 1,733.7 371.1 1,199.6 163.0 3,155,070 46508 61.4% 29.3% 2.8 11 47.8 105 34 85.2 17.6% 16.4% 18 KANSAS 3.6 44.4 2,314.5 342.7 1,721.9 249.9 2,913,314 47909 69.5% 34.0% 3.2 3 54.3 128 29 83.8 36.7 34.8 37.4 17.0% 19 KENTUCKY 4.9 48.4 1,897.4 345.7 1,323.5 228.2 4,467,673 39238 59.6% 25.1% 4.1 16 55.6 93 49 84.9 38.9 37 39.8 15.7% 16.1% 15.2% 36.9 34.8 37.4 16.3% 16.7% 16.0% 20 LOUISIANA 11.7 86.6 3,162.0 579.0 2,352.4 230.5 4,648,794 43157 84.2% 25.0% 4.7 8 66.4 101 60 87.2 44.7 42.6 45 13.8% 14.3% 13.3% 21 MAINE 1.5 14.0 1,245.6 174.8 1,016.7 54.0 1,344,212 45455 59.5% 33.2% 2.7 10.9 41 101 42 86.6 6,045,680 56041 97.5% 40.9% 3.5 9.1 54.2 105 45 86.4 38.7 36.6 39.8 14.9% 15.6% 14.2% 22 MARYLAND 9.0 152.2 1,950.2 278.9 1,485.0 186.2 52.4 1,179.8 179.0 911.8 89.0 6,892,503 62942 99.6% 45.0% 3 9.5 47.9 98 48 87.3 39.5 37.8 40.8 16.1% 16.5% 15.8% 23 MASSACHUSETTS 2.2 43787 82.0% 30.0% 4.1 12.9 44.4 71 33 86.2 39.7 38.1 40.9 16.5% 16.9% 16.0% 24 MICHIGAN 5.6 53.6 1,585.0 286.1 1,121.3 177.7 9,986.857 2.1 55.8 2,078.8 282.4 1,597.5 198.9 5,639,632 51079 77.9% 37.3% 3.2 8.9 41.2 95 27 85.9 38 36.6 38.7 15.0% 15.2% 14.8% 25 MINNESOTA 57.1 2,375.8 627.0 1,555.7 193.1 2,976,149 35791 48.4% 22.3% 5.5 19.5 63.4 111 59 86.9 37.5 35 37.9 17.1% 17.7% 16.6% 26 MISSISSIPPI 11.2 2,638.7 430.4 1,865.0 343.3 6,137,428 43529 75.1% 30.2% 3.3 9 54.5 115 42 84.8 38.6 36.7 39.6 16.0% 16.4% 15.5% 27 MISSOURI 9.3 80.8 19.2 2,193.2 270.1 1,700.6 222.4 1,068,778 44457 35.8% 33.6% 3.6 12.6 42.7 8 15 84.1 39.9 38.7 41.1 15.9% 16.5% 15.3% 28 MONTANA 2.5 257.7 1,934,408 49082 65.4% 33.2% 3 9 48.8 117 24 84.1 36.5 35.1 37.4 16.5% 16.8% 16.2% 29 NEBRASKA 2.3 40.9 2,039.3 245.3 1,536.3 4.6 106.7 2,322.1 503.5 1,453.0 365.6 3,080,156 45956 90.9% 25.7% 3.9 12.7 49.9 158 9.5 82.1 38 36.7 37.9 14.5% 14.6% 14.3% 30 NEVADA 31 NEW HAMPSHIRE 2.4 23.0 1,209.2 126.3 1,017.3 65.7 1,359,711 56978 63.1% 37.6% 2.6 7.5 43.8 90 43 86.1 42.9 41.4 43.3 15.1% 15.4% 14.8% 3.4 47 89.8 39.9 37.8 41 14.3% 14.9% 13.6% 32 NEW JERSEY 2.9 64.5 1,335.7 184.6 1,034.7 116.4 8,882,190 61023 100.0% 41.2% 9.1 52.7 94 8.6 111.6 3,112.7 696.8 1,988.8 427.2 2.096.829 39441 67.3% 27.7% 17.5 53.4 167 15 86.7 7.8 35.5 38.4 16.5% 17.1% 15.9% 33 NEW MEXICO 20 no s 20 0 15 08/ Sheet1 + + 73% Ready 8:04 AM Type here to search O i BOR PDF W 7/16/2021AutoSave O Off) State Crime - Excel Search Pete Stibbs PS X File Home Insert Page Layout Formulas Data Review View Help Share Comments B36 X V 284.6 A D E F G H J K L M N O P Q R S T U V W X Y Z 1 Table 5, Crime in the y State, 2019, Rate per 100,000 inhabitants Non-crime variables; units are as specified in row 2 descriptors nonnegligen Motor Robber Property Burglar Larcen vehicle Total state population Per capita % of state po % 25 ye unemploymentera # of avera % living Median age Median age, M Median age % 18-24/18 % male 18-24 % female 18-2 2 manslaughte y crime V y-theft theft https://ucr.fbi.gov/crir19/crime-in-the-u.s.-2019/downloads/download-printable-files Murder Robber PropCrime Burglar Larcen Car Thef Population PerCapIn %Metro Bache Unemploy %Pover Temp Sun Rain %SameH MedianAge MedAgeMale MedAgeFe %young %oyoungmale %youngfemale 4 State 24 MICHIGAN 53.6 1,585.0 286.1 1,121.3 177.7 9,986,857 43787 82.0% 30.0% 4.1 12.9 44.4 71 33 86.2 39.7 38.1 40.9 16.5% 16.9% 16.0% 3.6 2.1 55.8 2,078.8 282.4 1,597.5 198.9 5,639,632 51079 77.9% 37.3% 3.2 8.9 41.2 95 27 85.9 38 36.6 38.7 15.0% 15.2% 14.8% 25 MINNESOTA 26 MISSISSIPPI 11.2 57.1 2,375.8 627.0 1,555.7 193.1 2,976,149 35791 48.4% 22.3% 5.5 19.5 63.4 111 59 86.9 37.5 35 37.9 17.1% 17.7% 16.6% 9.3 80.8 2,638.7 430.4 1,865.0 343.3 6,137,428 43529 75.1% 30.2% 3.3 12.9 54.5 115 42 84.8 38.6 36.7 39.6 16.0% 16.4% 15.5% 27 MISSOURI 28 MONTANA 2.5 19.2 2,193.2 270.1 1,700.6 222.4 1,068,778 44457 35.8% 33.6% 3.6 12.6 42.7 82 15 84.1 39.9 38.7 41.1 15.9% 16.5% 15.3% 2.3 40.9 2,039.3 245.3 1,536.3 257.7 1,934,408 49082 65.4% 33.2% 3 9.9 48.8 117 24 84.1 36.5 35.1 37.4 16.5% 16.8% 16.2% 29 NEBRASKA 4.6 106.7 2,322.1 503.5 1,453.0 365.6 3,080,156 45956 90.9% 25.7% 3.9 12.7 49.9 158 9.5 82.1 38 36.7 37.9 14.5% 14.6% 14.3% 30 NEVADA 2.4 23.0 1,209.2 126.3 1,017.3 65.7 1,359,711 56978 63.1% 37.6% 2.6 7.5 43.8 9 43 86.1 42.9 41.4 43.3 15.1% 15.4% 14.8% 31 NEW HAMPSHIRE 32 NEW JERSEY 2.9 64.5 1,335.7 184.6 1,034.7 116.4 8,882,190 61023 100.0% 41.2% 3.4 9.1 47 89.8 39.9 37.8 41 14.3% 14.9% 13.6% 33 NEW MEXICO 8.6 111.6 3,112.7 696.8 1,988.8 427.2 2,096,829 39441 67.3% 27.7% 17.5 53.4 167 15 86.7 37.8 35.5 38.4 16.5% 17.1% 15.9% 34 NEW YORK 2.9 92.9 1,373.3 141.9 1,166.1 65.3 19,453,561 60329 93.0% 37.8% 3.8 13.1 45.4 63 42 89.5 38.8 36.6 39.8 15.8% 16.3% 15.3% 35 NORTH CAROLINA 6.0 72.5 2,357.3 519.1 1,666.0 172.2 10,488,084 42513 81.1% 32.3% 3.8 13.6 59 109 50 84.8 38.7 36.6 39.5 15.9% 16.8% 15.1% 3.1 23.5 1,977.0 342.2 1,399.6 235.2 762,062 51669 50.2% 30.4% 2.3 5 40.4 93 18 82.2 35.1 34.2 36.7 19.8% 20.3% 19.3% 36 |NORTH DAKOTA 4.6 75.7 2,055.7 375.5 1,520.4 159.7 11,689,100 44838 80.3% 29.3% 4.2 3 50.7 72 39 85.3 39.4 37.7 40.7 15.6% 16.0% 15.2% 37 OHIO 38 OKLAHOMA 6.7 59.9 2,845.3 671.7 1,835.5 338.1 3,956,971 42991 66.6% 26.2% 3.1 15.1 59.6 139 37 83.2 36.6 34.9 37.5 16.7% 17.1% 16.2% 2.8 54.0 2,730.6 349.1 2,021.5 360.0 4,217,737 46386 84.0% 34.5% 3.7 5 48.4 68 27 82.9 39.3 37.9 40.1 14.8% 15.1% 14.5% 39 OREGON 40 PENNSYLVANIA 5.2 76.1 1,403.4 182.4 1,124.2 96.8 12,801,989 51473 38.7% 32.3% 4.5 2 48.8 87 43 87.6 40.8 38.9 42.1 15.8% 16.1% 15.4% 41 RHODE ISLAND 2.4 39.5 1,534.8 219.1 1,187.5 128.2 1,059,361 50081 100.0% 34.8% 3.6 11.6 50.1 98 48 87.4 39.9 38.1 41.6 17.5% 17.8% 17.3% 42 SOUTH CAROLINA 9.0 64.0 2,940.3 533.4 2,116.1 290.8 5,148,714 40874 85.7% 29.6% 2.8 13.9 62.4 115 50 85.7 39.4 37 40.1 16.4% 17.2% 15.6% 1.9 22.0 1,771.0 299.1 1,273.4 198.5 884.659 49462 48.1% 29.7% 3 11.9 45.2 104 20 84.2 37 35.6 37.9 16.6% 16.9% 16.3% 43 SOUTH DAKOTA 7.3 90.1 2,652.6 437.4 1,934.4 280.9 6,829,174 44724 78.3% 28.7% 3.4 13.8 57.6 102 54 85.5 38.7 37.1 39.8 15.5% 16.0% 15.1% 44 TENNESSEE 45 TEXAS 4.9 100.0 2,390.7 392.8 1,730.6 267.2 28,995,881 47705 89.3% 30.8% 3.5 13.6 64.8 135 29 84.4 34.6 33.1 35 16.5% 17.0% 15.9% 46 UTAH 2.2 35.1 2,169.3 276.7 1,682.4 210.2 3,205,958 43533 89.6% 34.8% 2.5 8.8 48.6 125 12 83.1 30.8 29.6 30.6 19.4% 19.4% 19.3% 47 VERMONT 1.8 11.4 1,424.4 204.3 1,172.3 47.8 623,989 4950 35.5% 38.7% 2.3 10.1 42.9 58 43 86.7 42.9 41.1 43.5 16.7% 17.4% 16.1% 48 VIRGINIA 5.0 41.3 1,642.7 162.8 1,359.5 120.3 8,535,519 52015 87.7% 39.6% 2.7 9 55.1 100 44 84.7 38.2 36.4 39 15.5% 16.1% 15.0% 49 WASHINGTON 2.6 67.6 2,681.9 453.6 1,907.9 320.5 7,614,893 58077 89.8% 37.0% 4.1 9.8 48.3 58 38 82.3 37.7 36.5 38.6 15.0% 15.5% 14.6% 50 WEST VIRGINIA 4.4 21.1 1,583.4 328.7 1,119.7 135.0 1,792,147 38399 64.5% 21.1% 4.9 16.2 51.8 60 45 88.3 42.5 40.5 43 15.0% 15.4% 14.6% 3.0 51.4 1,471.4 217.6 1,127.0 126.8 5,822,434 47264 74.7% 31.3% 3.3 10.4 43.1 89 33 86.0 39.5 37.8 40.1 15.7% 15.9% 15.5% 51 WISCONSIN 2.2 11.6 1,571.1 241.2 1,206.7 123.2 578,759 55858 31.0% 29.1% 3.7 9.9 42 114 13 83.2 37.7 36.1 37.6 16.0% 16.4% 15.7% 52 WYOMING Sheet1 + + 73% Ready 8:05 AM Type here to search O Ei A PDF W 7/16/2021Pete Stibbs X AutoSave O Off) State Crime - Excel Search PS File Home Insert Page Layout Formulas Data Review View Help Share Comments B36 X V 284.6 A B C E F G H J K L M N P Q R S T U V W X Y 1 Table 5, Crime in the United States by State, 2019, Rate per 100,000 inhabitants Non-crime variables; units are as specified in row 2 descriptors Violenvated nonnegligen Motor t assaul Robber Property Burglar Larcen vehicle Total state 2 crime t manslaughte y crime y y-theft theft population Per capita % of state po % 25 ye unemploymenteras # of avera % living Median age Median age, M Median age % 18-24/18 % male 18-24 https://ucr.fbi.gov/crime-in-the-u.s/2019/crime-in-the-u.s.-2019/downloads/download-printable-files 4 State Violenseau Murder Robber PropCrime Burglar Larcen Car Thef Population PerCapIn %Metro Bache Unemploy %Pover Temp Sun Rain %SameH MedianAge MedAgeMale MedAgeFe %young youngmale 5 ALABAMA 510.8 381.0 1.3 80.4 2,674.4 531.9 1,886.1 256.5 4,903,185 39956 76.1% 26.3% 3 15.6 62.8 99 58 86.3 39 36.9 39.8 16.2% 16.7% 6 ARIZONA 455.3 311.9 5.0 88.1 2,440.5 394.3 1,796.9 249.4 7,278,717 41266 95.2% 30.2% 4.9 13.5 60.3 193 14 82.6 37.7 35.5 38.1 16.7% 17.3% 36.3 39 16.2% 16.6% 7 ARKANSAS 584.6 447.8 8.0 51.6 2,858.0 599.6 2,012.6 245.9 3,017,804 40278 63.4% 23.3% 3.5 16 60.4 123 51 84.6 38.1 441.2 267.1 4.3 132.4 2,331.2 386.1 1,586.3 358.8 39,512,223 57497 97.9% 35.0% 4.2 11.8 59.4 146 22 87.1 36.5 34.6 16.4% 16.9% 8 CALIFORNIA 37 9 COLORADO 381.0 246.3 3.8 63.6 2,590.7 348.4 1,858.3 384.0 5,758,736 53704 87.6% 42.7% 2.7 9.4 45.1 136 16 82.0 367 35.5 37.5 15.0% 15.5% 10 CONNECTICUT 183.6 105.0 2.9 54.1 1,426.6 180.7 1,078.7 167.3 3,565,287 65906 83.2% 39.8% 3.6 9.9 49 82 50 87.9 41 38.8 42.1 15.3% 16.0% 422.6 304.7 4.9 81.1 2,252.2 304.8 1,782.7 164.7 973,764 47978 100.0% 33.2% 3.7 11.2 55.3 97 46 87.4 40.6 37.9 41 16.0% 16.5% 1 DELAWARE 12 FLORIDA 378.4 258.3 5.2 75.5 2,145.7 295.2 1,668.7 181.8 21,477,737 46339 96.8% 30.7% 3.3 12.7 70.7 101 35 84.5 42 40 42.9 15.0% 15.6% 340.7 232.0 6.2 75.0 2,375.8 372.1 1,779.8 223.9 10,617,423 42863 83.1% 32.5% 3.5 13.5 63.5 112 51 84.9 36.7 34.7 37.3 16.0% 16.7% 13 GEORGIA 14 IDAHO 223.8 167.9 2.0 8.7 1,219.5 219.7 911.8 87.9 1,787,065 41632 74.3% 28.7% 2.8 11 44.4 120 19 82.8 36.4 34.6 36.2 16.3% 16.6% 15 ILLINOIS 406.9 254.0 6.6 98.4 1,846.5 271.7 1,426.6 148.2 2,671,821 51706 88.8% 35.8% 4 11.4 51.8 95 39 87.3 38.1 35.9 38.6 15.5% 15.9% 16 INDIANA 370.8 249.3 5.6 79.2 1,971.0 323.7 1,443.4 203.8 6,732,219 43960 78.2% 26.9% 3.2 11.9 51.7 88 42 85.3 37.7 36 38.6 16.5% 16.9% 266.6 200.4 1.9 27.4 1,733.7 371.1 1,199.6 163.0 3,155,070 46508 61.4% 29.3% 2.8 11 47.8 105 34 85.2 38.2 36.6 39.4 17.0% 17.4% 17 IOWA 18 KANSAS 410.8 314.2 3.6 44.4 2,314.5 342.7 1,721.9 249.9 2,913,314 47909 69.5% 34.0% 3.2 11.3 54.3 128 29 83.8 36.7 34.8 37.4 17.0% 17.6% 19 KENTUCKY 217.1 128.6 4.9 48.4 1,897.4 345.7 1,323.5 228.2 4,467,673 39238 59.6% 25.1% 4.1 16 55.6 93 49 84.9 38.9 37 39.8 15.7% 16.1% 20 LOUISIANA 549.3 402.1 11.7 86.6 3,162.0 579.0 2,352.4 230.5 4,648,794 43157 84.2% 25.0% 4.7 18.8 60 87.2 36.9 34.8 37.4 16.3% 16.7% 21 MAINE 115.2 61.3 1.5 14.0 1,245.6 174.8 1,016.7 54.0 1,344,212 45455 59.5% 33.2% 2.7 10.9 41 101 86.6 44.7 42.6 45 13.8% 14.3% 22 MARYLAND 454.1 261.3 9.0 152.2 1,950.2 278.9 1,485.0 186.2 6,045,680 56041 97.5% 40.9% 3.5 9.1 54.2 105 45 86.4 38.7 36.6 39.8 14.9% 15.6% 23 MASSACHUSETTS 327.6 241.0 2.2 52.4 1,179.8 179.0 911.8 89.0 6,892,503 62942 99.6% 45.0% 3 9.5 47.9 98 48 87.3 39.5 37.8 40.8 16.1% 16.5% 24 MICHIGAN 437.4 305.9 5.6 53.6 1,585.0 286.1 1,121.3 177.7 9.986,857 43787 82.0% 30.0% 4.1 12.9 71 33 86.2 39.7 38.1 40.9 16.5% 16.9% 236.4 135.1 2.1 55.8 2,078.8 282.4 1,597.5 198.9 5,639,632 51079 77.9% 37.3% 3.2 9 41.2 9 27 85.9 38 36.6 38.7 15.0% 15.2% 25 MINNESOTA 26 MISSISSIPPI 277.9 184.6 11.2 57.1 2,375.8 627.0 1,555.7 193.1 2,976,149 35791 48.4% 22.3% 5.5 19.5 63.4 111 59 86.9 37.5 35 37.9 17.1% 17.7% 27 MISSOURI 495.0 357.4 9.3 80.8 2,638.7 430.4 1,865.0 343.3 6,137,428 43529 75.1% 30.2% 3.3 12.9 54.5 115 42 84.8 38.6 36.7 39.6 16.0% 16.4% 28 MONTANA 404.9 324.9 2.5 19.2 2,193.2 270.1 1,700.6 222.4 1,068,778 44457 35.8% 33.6% 3.6 12.6 42.7 8 15 84.1 39.9 38.7 41.1 15.9% 16.5% 29 NEBRASKA 300.9 192.9 2.3 40.9 2,039.3 245.3 1,536.3 257.7 1,934,408 49082 65.4% 33.2% 3 9.9 48.8 117 24 84.1 36.5 35.1 37.4 16.5% 16.8% 493.8 312.3 4.6 106.7 2,322.1 503.5 1,453.0 365.6 3,080,156 45956 90.9% 25.7% 3.9 12.7 49.9 158 9.5 82.1 38 36.7 37.9 14.5% 14.6% 30 NEVADA 31 NEW HAMPSHIRE 152.5 83.7 2.4 23.0 1,209.2 126.3 1,017.3 65.7 1,359,711 56978 63.1% 37.6% 2.6 7.5 43.8 90 43 86.1 42.9 41.4 43.3 15.1% 15.4% 32 NEW JERSEY 206.9 122.2 2.9 64.5 1,335.7 184.6 1,034.7 116.4 8,882,190 61023 100.0% 41.2% 3.4 9.1 52.7 94 47 89.8 39.9 37.8 41 14.3% 14.9% 33 NEW MEXICO 832.2 650.5 8.6 111.6 3,112.7 696.8 1,988.8 427.2 2,096,829 39441 67.3% 27.7% 17.5 53.4 167 15 86.7 37.8 35.5 38.4 16.5% 17.1% no s 20 0 15 00/ Sheet1 (+ + 73% Ready 8:03 AM Type here to search O BOR PDF w 7/16/2021