Assignment 2_CRM341(1) (1)

7. What else did you learn from your readings that you found interesting about NIBRS? (5 pts) Part 2. The goal of this exercise is to explore crime in the US using Crime Data Explorer (posted on Blackboard) website. In this exercise, we will explore general trends about crime, how different demographic groups are affected by crime and relationships between victims and offenders (30 pts). Pull all the population rates in the US for each violent crime category (i.e., homicide, rape, robbery, aggravated assault) and each property crime category (i.e, arson, burglary, larceny-theft, motor-vehicle theft) rates from 2000-2020. (Tip)An Example of Organization Layout in Excel is below: Dates- Vertical Line; Crime Type- Horizonal Line. Note. The rates below are made up. Table 1. Violent Crime in USA Violent Crime Homicide Rape Robbery Aggravated Assault 2000 45166.55 506.5 456.1 465.2 5616.1 1. Create a line graph in excel of each of the violent crime categories. Table 1. Violent Crime in USA Violent Crime Robbery Homicide Rape Aggravated Assault 2000 506.5 145 5.5 32 324 2001 504.5 148.5 5.6 31.8 318.6 2002 494.4 146.1 5.6 33.1 309.5 2003 475.8 142.5 5.7 32.3 296.4 2004 463.2 136.7 5.5 32.4 288.6 2005 469 140.8 5.6 31.8 290.8 2006 479.3 150 5.8 31.6 292 2007 471.8 148.2 5.7 30.6 287.2 2008 458.6 145.9 5.4 29.8 277.5 2009 431.9 133.1 5 29.1 264.7 2010 404.5 119.3 4.8 27.7 252.8 2011 387.1 113.9 4.7 27 241.5 2012 387.8 113.1 4.7 27.1 242.8 2013 369.1 109 4.4 25.9 229.6