Description
Open “Prep 2.1” Excel file that I attached here. 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. Question 1: Open “Response Times” sheet.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. Question 2: Open “Homicide” sheet. 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?
Unformatted Attachment Preview
21 minutes or more
16-20 minutes
11-15 minutes
6-10 minutes
Less than 6 minutes
Response time 2015 (f)Response time 2016 (f)Response time 2017 (f)
43
44
55
52
55
69
112
145
178
154
197
292
91
114
166
Response time 2018 (f) Response time 2019 (f)
35
45
75
70
180
133
375
395
210
250
USA
State
New Jersey
Iowa
Alabama
Texas
California
1997
2001
Homicides
Population Homicides Population
338 8,053,000
336
8,484,431
52 2,852,000
50
2,923,179
426 4,139,000
379
4,464,356
1,327 19,439,000
1,332
21,325,018
2,579 32,268,000
2,206
34,501,130
Canada
1997
2001
Province
Homicides
Population Homicides Population
Nova Scotia
24
936,100
9
942,900
Quebec
132 7,323,600
149
7,417,700
Ontario
178 11,387,400
170
12,068,300
Manitoba
31 1,137,900
34
1,150,800
British Columbia
116 3,997,100
85
4,141,300
Source: Statistics Canada
Purchase answer to see full
attachment
