Open “Prep 2.1” Excel file. Data for the two questions can be found on different sheets. Use the Excel file for computation and charts and a Word document for your written answers. Save and upload both files to Canvas.
Open “Response Times” sheet. (1 point)
As part of an evaluation of the efficiency of your local police force, you have gathered data on police response time to calls for assistance during multiple years (response times were rounded off to whole minutes). Convert the frequency distributions into percentages and construct a chart appropriate to display all relevant data. Write a paragraph (about 150 words) analyzing the changes in response times and total number of calls over the years.
2. Open “Homicide” sheet. (1 point)
Calculate the homicide rate per 100,000 population for each state/province for each year.
Which state and which province had the highest homicide rates in 1997?
Which state and which province had the highest homicide rates in 2001?
Which society (country) seems to have a higher homicide rate?
Which society seems to have the largest change in homicide rates? What is the direction of the change