Criminal justice

Select a police agency for which you can access their index of Part I offenses. If you are having issues finding crime data, you could use the open-crime data offered by the Seattle Police Department at this link. Create a spreadsheet with the Part I offenses for the past 10 years. This spreadsheet should include data for the following offenses: Homicide, rape, robbery, aggravated assault, burglary, motor vehicle theft, larceny-theft, and arson. Develop a chart displaying the trends associated with the total crime for the city. Develop a chart comparing the rates associated with each of the Part I offenses. Develop a chart that displays the proportion of crime on each Part I offense.    

Sample Solution