(Solved) Crime in the United States by State, 2012 State ALABAMA

Posted on : by : admin

$ 29.00

Crime in the United States by State, 2012 State ALABAMA

SKU: 7925

Description

  

I need data in an excel file for these variables across the U.S. 50 states in year 2012… Gini coefficient, median income, gender, nationality, poverty, and number of high school grads. I will attach the excel file with some other variables i have already found, please add the founded variables to this file.

Crime in the United States
by State, 2012 State
ALABAMA Area
State Total ALASKA State Total Population
4,822,023
Rate per 100,000 inhabitants
731,449
Rate per 100,000 inhabitants ARIZONA 6,553,255 State Total
Rate per 100,000 inhabitants ARKANSAS 2,949,131 State Total
Rate per 100,000 inhabitants CALIFORNIA 38,041,430 State Total
Rate per 100,000 inhabitants COLORADO State Total CONNECTICUT State Total 5,187,582
Rate per 100,000 inhabitants
3,590,347
Rate per 100,000 inhabitants DELAWARE 917,092 State Total
Rate per 100,000 inhabitants DISTRICT OF COLUMBIA1 Total FLORIDA State Total 632,323
Rate per 100,000 inhabitants
19,317,568
Rate per 100,000 inhabitants GEORGIA 9,919,945 State Total
Rate per 100,000 inhabitants HAWAII 1,392,313 State Total
Rate per 100,000 inhabitants IDAHO 1,595,728 State Total
Rate per 100,000 inhabitants ILLINOIS State Total INDIANA State Total 12,875,255
Rate per 100,000 inhabitants
6,537,334
Rate per 100,000 inhabitants Violent
crime
21,693
449.9
4,412
603.2
28,108
428.9
13,835
469.1
160,944
423.1
16,023
308.9
10,160
283.0
5,020
547.4
7,864
1,243.7
94,087
487.1
37,591
378.9
3,330
239.2
3,318
207.9
53,403
414.8
22,602
345.7 Property
crime
168,878
3,502.2
20,037
2,739.4
231,930
3,539.2
107,941
3,660.1
1,049,465
2,758.7
139,270
2,684.7
76,834
2,140.0
30,639
3,340.9
30,736
4,860.8
632,988
3,276.7
338,329
3,410.6
42,817
3,075.2
31,651
1,983.5
332,013
2,578.7
198,032
3,029.2 State
IOWA Area
State Total Population
3,074,186
Rate per 100,000 inhabitants KANSAS 2,885,905 State Total
Rate per 100,000 inhabitants KENTUCKY 4,380,415 State Total
Rate per 100,000 inhabitants LOUISIANA State Total MAINE State Total 4,601,893
Rate per 100,000 inhabitants
1,329,192
Rate per 100,000 inhabitants MARYLAND 5,884,563 State Total
Rate per 100,000 inhabitants MASSACHUSETTS 6,646,144 State Total
Rate per 100,000 inhabitants MICHIGAN 9,883,360 State Total
Rate per 100,000 inhabitants MINNESOTA State Total MISSISSIPPI State Total 5,379,139
Rate per 100,000 inhabitants
2,984,926
Rate per 100,000 inhabitants MISSOURI 6,021,988 State Total
Rate per 100,000 inhabitants MONTANA 1,005,141 State Total
Rate per 100,000 inhabitants NEBRASKA 1,855,525 State Total
Rate per 100,000 inhabitants NEVADA State Total NEW HAMPSHIRE State Total 2,758,931
Rate per 100,000 inhabitants
1,320,718
Rate per 100,000 inhabitants NEW JERSEY 8,864,590 State Total
Rate per 100,000 inhabitants NEW MEXICO 2,085,538 State Total
Rate per 100,000 inhabitants NEW YORK3 19,570,261 State Total
Rate per 100,000 inhabitants NORTH CAROLINA 9,752,073 State Total
Rate per 100,000 inhabitants Violent
crime
8,112
263.9
10,232
354.6
9,752
222.6
22,868
496.9
1,631
122.7
28,055
476.8
26,953
405.5
44,922
454.5
12,419
230.9
7,786
260.8
27,155
450.9
2,736
272.2
4,814
259.4
16,763
607.6
2,481
187.9
25,727
290.2
11,660
559.1
79,610
406.8
34,464
353.4 Property
crime
69,839
2,271.8
90,710
3,143.2
111,826
2,552.9
162,936
3,540.6
33,361
2,509.9
162,031
2,753.5
143,089
2,153.0
250,101
2,530.5
138,152
2,568.3
83,906
2,811.0
199,590
3,314.4
25,970
2,583.7
51,118
2,754.9
77,510
2,809.4
30,693
2,324.0
181,481
2,047.3
75,094
3,600.7
376,140
1,922.0
328,594
3,369.5 State
NORTH DAKOTA Area
State Total Population
699,628
Rate per 100,000 inhabitants OHIO 11,544,225 State Total
Rate per 100,000 inhabitants OKLAHOMA 3,814,820 State Total
Rate per 100,000 inhabitants OREGON State Total PENNSYLVANIA State Total 3,899,353
Rate per 100,000 inhabitants
12,763,536
Rate per 100,000 inhabitants RHODE ISLAND 1,050,292 State Total
Rate per 100,000 inhabitants SOUTH CAROLINA 4,723,723 State Total
Rate per 100,000 inhabitants SOUTH DAKOTA 833,354 State Total
Rate per 100,000 inhabitants TENNESSEE State Total TEXAS State Total 6,456,243
Rate per 100,000 inhabitants
26,059,203
Rate per 100,000 inhabitants UTAH 2,855,287 State Total
Rate per 100,000 inhabitants VERMONT 626,011 State Total
Rate per 100,000 inhabitants VIRGINA 8,185,867 State Total
Rate per 100,000 inhabitants WASHINGTON 6,897,012 State Total
Rate per 100,000 inhabitants WEST VIRGINIA 1,855,413 State Total
Rate per 100,000 inhabitants WISCONSIN 5,726,398 State Total
Rate per 100,000 inhabitants WYOMING 576,412 State Total
Rate per 100,000 inhabitants Violent
crime
1,712
244.7
34,595
299.7
17,902
469.3
9,653
247.6
44,503
348.7
2,651
252.4
26,397
558.8
2,682
321.8
41,550
643.6
106,476
408.6
5,876
205.8
893
142.6
15,564
190.1
20,386
295.6
5,869
316.3
16,064
280.5
1,161
201.4 Property
crime
14,063
2,010.1
359,883
3,117.4
129,743
3,401.0
125,723
3,224.2
276,496
2,166.3
27,017
2,572.3
180,550
3,822.2
17,168
2,060.1
217,664
3,371.4
876,059
3,361.8
85,424
2,991.8
15,016
2,398.7
176,985
2,162.1
252,333
3,658.6
43,878
2,364.9
140,513
2,453.8
13,222
2,293.8 State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime State Area Population Violent
crime Property
crime Total Law Enforcement
Unemployment
EmployeesPopulation
rate
total crime
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count 18751.41
3146.291
12032
1968
22469.01
5.0E+008
7.689078
2.580086
115591
1677
117268
956322
51 7.372549
0.23974
7.5
7.1
1.712084
2.931231
-0.10123
-0.2301
8.1
3.1
11.2
376
51 6155177
976653
4380415
#N/A
6974698
4.9E+013
8.911858
2.675918
37465018
576412
38041430
3.1E+008
51 199802
32429.08
147645
#N/A
231589.9
5.4E+010
8.712839
2.713165
1196026
14383
1210409
10189902
51 State
ALABAMA
ALASKA
ARIZONA
ARKANSAS
CALIFORNIA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA1
FLORIDA
GEORGIA
HAWAII
IDAHO
ILLINOIS
INDIANA State
IOWA
KANSAS
KENTUCKY
LOUISIANA
MAINE
MARYLAND
MASSACHUSETTS
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK3
NORTH CAROLINA
NORTH DAKOTA
OHIO
OKLAHOMA
OREGON
PENNSYLVANIA
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGINA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING State State State State State State State State State State State State State SUMMARY OUTPUT
Regression Statistics
Multiple R 0.980554
R Square 0.961487
Adjusted R 0.959028
Standard E 46877.22
Observatio
51
ANOVA
df
Regressio
Residual
Total SS
MS
F Significance F
3 2.6E+012 8.6E+011 391.1179 3.2E-033
47 1.0E+011 2.2E+009
50 2.7E+012 Coefficients
Standard Error t Stat
Intercept
-14614.7 30134.81 -0.48498
Total Law -2.46664 1.316471 -1.87367
Unemploym1901.287 4223.959 0.45012
Population 0.040072 0.004206 9.526981 P-value Lower 95%Upper 95%
Lower 95.0%
Upper 95.0%
0.629945 -75238.1 46008.72 -75238.1 46008.72
0.0672 -5.11504 0.18176 -5.11504 0.18176
0.654693 -6596.22 10398.8 -6596.22 10398.8
1.5E-012 0.031611 0.048534 0.031611 0.048534 RESIDUAL OUTPUT PROBABILITY OUTPUT Observation
Predicted total crime
Residuals
1
162388 28182.99
2 23340.96 1108.04
3
207040 52998.01
4 95448.84 26327.16
5 1240310 -29900.8
6 165685.1 -10392.1
7 119704.7 -32710.7
8 28052.2 7606.796
9 15561.55 23038.45
10 613630.1 113444.9
11 314629.9 61290.06
12 43410.36 2736.643
13 52498.9 -17529.9
14
406194
-20778
15 233453.6 -12819.6
16 100080.2 -22129.2
17 88002.86 12939.14
18 152513.8 -30935.8
19
135529 50274.95
20 45938.06 -10946.1
21 190211.5 -125.525
22 216888.7 -46846.7
23 341596.6 -46573.6
24 178346.7 -27775.7
25 108143.7 -16451.7
26
191942 34802.96
27 31139.1 -2433.1 Percentile total crime
0.980392
14383
2.941176
15775
4.901961
15909
6.862745
19850
8.823529
24449
10.78431
28706
12.7451
29668
14.70588
33174
16.66667
34969
18.62745
34992
20.58824
35659
22.54902
38600
24.5098
46147
26.47059
49747
28.43137
55932
30.39216
77951
32.35294
86754
34.31373
86994
36.27451
91300
38.23529
91692
40.19608
94273
42.15686
100942
44.11765
121578
46.07843
121776
48.03922
135376
50
147645
51.96078
150571 28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51 55153.07
93934.19
40291.26
264853.4
67600.25
590024.8
311585.8
14460.67
414482.4
117633.5
133908.7
437180.1
39735.42
154835.2
19999.35
194138.4
862615.8
92700.2
15840.9
266545.5
242109.2
62957.47
182191.2
13444.48 778.9306
338.8128
-7117.26
-57645.4
19153.75
-134275
51472.19
1314.332
-20004.4
30011.45
1467.317
-116181
-10067.4
52111.82
-149.35
65075.59
119919.2
-1400.2
68.09871
-73996.5
30609.77
-13210.5
-25614.2
938.5157 53.92157
155293
55.88235
156577
57.84314
170042
59.80392
185804
61.76471
190086
63.72549
190571
65.68627
192549
67.64706
206947
69.60784
207208
71.56863
220634
73.52941
226745
75.4902
259214
77.45098
260038
79.41176
272719
81.37255
295023
83.33333
320999
85.29412
363058
87.2549
375920
89.21569
385416
91.17647
394478
93.13725
455750
95.09804
727075
97.05882
982535
99.01961 1210409 total crime -100000
-150000 total crime total crime Residuals Residuals Residuals -200000 Population
2000000 Population Line Fit Plot
Normal Probability Pl total crime
total crime Upper 95.0% Total Law Enforcement Employees Residual Plot
Unemployment rate Residual Plot
Population Residual Plot
200000
150000
0
100000
Total200000
Law
Enforcement100000
Employees 150000Total Law Enforcement Employees Line Fit Plot
0
50000
50000
-200000
0
0
Unemployment
rate Line Fit Plot
rate
2 -50000
3
4 0 5Unemployment
6
7
820,000,000
9 10 30,000,000
11 12 40,000,000
10,000,000 Predicted total
total crime
crime
1000000
1500000
Total Law Enforcement Employees
Predicted totaltotal crime
0 50000 100000 150000
0 1000000 1500000
crime
2 3500000
4 5 6 7 8 9 101112
Predicted total
Unemployment
rate
1000000
crime
0
500000
20,000,000
Population
0
40,000,000
0
0
20
40
60
80
Sample Percentile s Line Fit Plot
rate Line Fit Plot tion Line Fit Plot
crime
NormaltotalProbability
Plot
12 Predicted totaltotal crime
crime
Predicted total
crime ,000
ation
40,000,000
0
20
40
60
80
Sample Percentile 100 120 Total Law Enforcement
Unemployment
EmployeesPopulation
rate
total crime
Total Law
1
Unemploym0.398112
1
Population 0.974097 0.380135
1
total crime 0.941862 0.377545 0.979069
1