please use the link for the sheet also no plagriazm and use references please

please use the link for the sheet also no plagriazm and use references please

Assignment DetailsIn the last 4 weeks, you have explored the development of the United States police service. You have learned about the fundamental principles shaping the police service, key reform periods, and several issues and challenges facing the service.In this activity, you will further develop your analytical and technology skills by collecting, analyzing, and presenting crime statistics for either your local agency or the closest agency whose crime data have been made available.The specific steps are as follows: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 atthis 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.Submit your Excel spreadsheet and charts.