You are the Chief of Police in the City of Omaha, Nebraska with a population of 446,000

You are the Chief of Police in the City of Omaha, Nebraska with a population of 446,000.   You are wanting to know if your department (your leadership) is having an adequate effect on the crime rate when compared to other cities of similar population.   Perhaps if you find a city which has had a greater effect on the crime rate, you can explore to see what they are doing differently as they target crime in their city.

a.  You are interested in the rate of crime for the following crimes: murder, theft, aggravated assault, robbery, rape, auto theft,  burglary and crime totals.

b. for the years 2014, 2015, 2016, 2017, and 2018, a period of five years.   Use these years only.  

c.  You are interested in comparing the City of Omaha to 4 other cities of similar population to see if there is any difference between the rates of the different crimes over time.

Data Analysis

I will be placing my data tables here and explaining - how I calculated the values (below is one of my data tables.  (if you have chosen your cities - indicate what city in each of the tables)