(solution) qattachments_7ba977e35e9241dd354eb720653cbf8c4a7b7bc2 Year

(solution) qattachments_7ba977e35e9241dd354eb720653cbf8c4a7b7bc2 Year

I need help on my last homework question.

attached you will find the necessary documents to proceed. 

qattachments_7ba977e35e9241dd354eb720653cbf8c4a7b7bc2
Year Population Violent crime Violent crime rate Murder and nonnegligent manslaughter
1994 260327021
1857670
713.6
23326
1995 262803276
1798792
684.5
21606
1996 265228572
1688540
636.6
19645
1997 267783607
1636096
611
18208
1998 270248003
1533887
567.6
16974
1999 272690813
1426044
523
15522
2000 281421906
1425486
506.5
15586
2001 285317559
1439480
504.5
16037
2002 287973924
1423677
494.4
16229
2003 290788976
1383676
475.8
16528
2004 293656842
1360088
463.2
16148
2005 296507061
1390745
469
16740
2006 299398484
1435123
479.3
17309
2007 301621157
1422970
471.8
17128
2008 304059724
1394461
458.6
16465
2009 307006550
1325896
431.9
15399
2010 309330219
1251248
404.5
14722
2011 311587816
1206005
387.1
14661
2012 313873685
1217057
387.8
14856
2013 316128839
1163146
367.9
14196 Page 1 qattachments_7ba977e35e9241dd354eb720653cbf8c4a7b7bc2
Murder and nonnegligent manslaughter rate Rape
Rape rate Robbery Robbery rate
9 102216
39.3 618949
237.8
8.2 97470
37.1 580509
220.9
7.4 96252
36.3 535594
201.9
6.8 96153
35.9 498534
186.2
6.3 93144
34.5 447186
165.5
5.7 89411
32.8 409371
150.1
5.5 90178
32 408016
145
5.6 90863
31.8 423557
148.5
5.6 95235
33.1 420806
146.1
5.7 93883
32.3 414235
142.5
5.5 95089
32.4 401470
136.7
5.6 94347
31.8 417438
140.8
5.8 94472
31.6 449246
150
5.7 92160
30.6 447324
148.3
5.4 90750
29.8 443563
145.9
5 89241
29.1 408742
133.1
4.8 85593
27.7 369089
119.3
4.7 84175
27 354746
113.9
4.7 85141
27.1 355051
113.1
4.5 79770
25.2 345031
109.1 Page 2 qattachments_7ba977e35e9241dd354eb720653cbf8c4a7b7bc2
Aggravated assault Aggravated assault rate Property crime Property crime rate Burglary
1113179
427.6
12131873
4660.2 2712774
1099207
418.3
12063935
4590.5 2593784
1037049
391
11805323
4451 2506400
1023201
382.1
11558475
4316.3 2460526
976583
361.4
10951827
4052.5 2332735
911740
334.3
10208334
3743.6 2100739
911706
324
10182584
3618.3 2050992
909023
318.6
10437189
3658.1 2116531
891407
309.5
10455277
3630.6 2151252
859030
295.4
10442862
3591.2 2154834
847381
288.6
10319386
3514.1 2144446
862220
290.8
10174754
3431.5 2155448
874096
292
10019601
3346.6 2194993
866358
287.2
9882212
3276.4 2190198
843683
277.5
9774152
3214.6 2228887
812514
264.7
9337060
3041.3 2203313
781844
252.8
9112625
2945.9 2168459
752423
241.5
9052743
2905.4 2185140
762009
242.8
9001992
2868 2109932
724149
229.1
8632512
2730.7 1928465 Page 3 qattachments_7ba977e35e9241dd354eb720653cbf8c4a7b7bc2
Burglary rate Larceny-theft Larceny-theft rate Motor vehicle theft Motor vehicle theft rate
1042.1
7879812
3026.9
1539287
591.3
987
7997710
3043.2
1472441
560.3
945
7904685
2980.3
1394238
525.7
918.8
7743760
2891.8
1354189
505.7
863.2
7376311
2729.5
1242781
459.9
770.4
6955520
2550.7
1152075
422.5
728.8
6971590
2477.3
1160002
412.2
741.8
7092267
2485.7
1228391
430.5
747
7057379
2450.7
1246646
432.9
741
7026802
2416.5
1261226
433.7
730.3
6937089
2362.3
1237851
421.5
726.9
6783447
2287.8
1235859
416.8
733.1
6626363
2213.2
1198245
400.2
726.1
6591542
2185.4
1100472
364.9
733
6586206
2166.1
959059
315.4
717.7
6338095
2064.5
795652
259.2
701
6204601
2005.8
739565
239.1
701.3
6151095
1974.1
716508
230
672.2
6168874
1965.4
723186
230.4
610
6004453
1899.4
699594
221.3 Page 4