+1 (315) 557-6473 

Chicago Crime Report using SPSS Homework Solution

Different Types of Crimes in Chicago

Word Document (with responses to the assignment questions).

1. Using the data file BUCJ59105ACHICAGO.SAV: You have been asked to develop a statistical profile of crime in the city in 2020 and answer the following questions. In your answer, use an appropriate tabular or graphic technique that displays the answer to others in an effective way:

a. What were the three most frequent offenses occurring in the city in 2020?

It can be seen that Battery, Theft, and criminal damage are the three most frequent offenses occurring in the city in 2020.

Crime Rate 1

b. What were the three districts that had the highest number of crimes reported?

District numbers 11, 6, and 8 were the three districts that had the highest number of crimes reported.

Crime Rate 2

c. Homicide is a concern – what districts reported the most homicides in 2020?

Districts 11, 6, and 7 reported the top three homicides in %age in 2020.

Crime Rate 3

d. What percent of all crimes reported in 2020 were cleared by arrest?

15.8% of all crimes reported in 2020 were cleared by arrest

Crime Rate 4

e. What percent of all crimes involved a domestic component?

18.9% of all crimes involved a domestic component.

Crime Rate 5

2. Using the file BUCJ59105CCHICAGOCCAS.SAV

a. Compute two new variables:



b. How many community areas are there in Chicago?

There are 77 community areas in Chicago.

Community Area

FrequencyPercentValid PercentCumulative Percent
1-Rogers park11.31.31.3
2-West Ridge
4-Lincoln Square
5-North Center6.5
6-Lake View
7-Lincoln Park
8-Near North Side 11.31.310.4
9-Edison Park 11.31.311.7
10-Norwood Park 11.31.313.0
11-Jefferson Park 11.31.314.3
12-Forest Glen 11.31.315.6
13-North Park 11.31.316.9
14-Albany Park 11.31.318.2
15-Portage Park 11.31.319.5
16-Irving Park 11.31.320.8
17-Dunning 11.31.322.1
18-Montclare 11.31.323.4
19-Belmont Cragin 11.31.324.7
20-Hermosa 11.31.326.0
21-Avondale 11.31.327.3
22-Logan Square 11.31.328.6
23-Humboldt Park 11.31.329.9
24-West Town 11.31.331.2
25-Austin 11.31.332.5
26-West Garfield Park 11.31.333.8
27-East Garfield Park 11.31.335.1
28-Near West Side 11.31.336.4
29-North Lawndale 11.31.337.7
30-South Lawndale 11.31.339.0
31-Lower West Side
32-The Loop 11.31.341.6
33-Near South Side 11.31.342.9
34-Armour Square 11.31.344.2
35-Douglas 11.31.345.5
36-Oakland 11.31.346.8
37-Fuller Park 11.31.348.1
38-Grand Boulevard 11.31.349.4
39-Kenwood 11.31.350.6
40-Washington Park 11.31.351.9
41-Hyde Park 11.31.353.2
42-Woodlawn 11.31.354.5
43-South Shore 11.31.355.8
44-Chatham 11.31.357.1
45-Avalon Park 11.31.358.4
46-South Chicago 11.31.359.7
47-Burnside 11.31.361.0
48-Calumet Heights 11.31.362.3
49-Roseland 11.31.363.6
50-Pullman 11.31.364.9
51-South Deering 11.31.366.2
52-East Side 11.31.367.5
53-West Pullman 11.31.368.8
54-Riverdale 11.31.370.1
55-Hegewisch 11.31.371.4
56-Garfield Ridge 11.31.372.7
57-Archer Heights 11.31.374.0
58-Brighton Park 11.31.375.3
59-McKinley Park 11.31.376.6
60-Bridgeport 11.31.377.9
61-New City 11.31.379.2
62-West Elsdon 11.31.380.5
63-Gage Park 11.31.381.8
64-Clearing 11.31.383.1
65-West Lawn 11.31.384.4
66-Chicago Lawn 11.31.385.7
67-West Englewood 11.31.387.0
68-Englewood 11.31.388.3
69-Greater Grand Crossing 11.31.389.6
70-Ashburn 11.31.390.9
71-Auburn Gresham 11.31.392.2
72-Beverly 11.31.393.5
73-Washington Heights 11.31.394.8
74-Mount Greenwood 11.31.396.1
75-Morgan Park 11.31.397.4
76-O'Hare 11.31.398.7
77-Edgewater 11.31.3100

c. For each of these variables, what is the minimum rate? The maximum rate? The median rate? The mean rate? The standard deviation?

These values for the two variables are presented in the table below:

Crime Rate 6

d. What variables for the neighborhood would you want to consider looking at to explore these differences?

Unemployment rates, median income rate, ethnicity variables (white, Hispanic, black, Asian, others), education (less than High school, High school, some college, associate, Bachelor’s and graduate), median age are the variables for the neighborhood that could be considered to explore these differences.

3. Analysis of Variance. Using the file BUCJ59105CCHICAGOCCAS.SAV, look at the relationship between unemployment rates and burglary rates using an analysis of variance model. The variable UNEMPGROUP assigns neighborhoods to one of three groups: low unemployment rate (under 6.5%); moderate unemployment rate (6.5% up to 13.8%); and high unemployment (13.8% or higher). This variable creates three equal groups of 25 neighborhoods each. The two neighborhoods with the highest unemployment rates were not assigned to a group.

a. Consider the relationship between unemployment rates in the neighborhood and burglary rates. Perform a one-way analysis of variance

Crime Rate 7.PNG

Crime Rate 8

Post Hoc Tests

Crime Rate 9

b. What are the mean burglary rates for each of the three groups?

Mean burglary rates for

Low unemployment (under 6.5%) - 0.0023

Moderate unemployment (6.5% upto 13.8%) - 0.0022

High unemployment (13.8% or higher) - 0.0054

c. Is there a significant difference between the groups? What statistic did you use to make this conclusion

The p-value of the F-stat is close to zero. Since the p-value is less than 0.05 at the 5% alpha level, the results conclude that there is a significant difference between the groups.

F-test is used to make this conclusion.

d. Which groups are different from each other? Are any groups not statistically significantly different?

There is a significant difference between the following groups:

- Low unemployment and high unemployment

- Moderate unemployment & High unemployment

There is no significant difference between the following groups:

- Low unemployment and moderate unemployment

e. Based on the results of your analysis, what policies would you recommend to city leadership to reduce burglary rates in the city? Can you relate your findings to a theory from criminology?

 We recommend that city leadership might try to provide employment options to the unemployed. Increasing the cost of crime can also help reduce such criminal activities. The rational choice theory of criminology suggests that people make rational choices and they will be willing to commit a crime if it helps serve their interest. The income of the unemployed youth is lower and they have the option of using illegal or criminal activities for monetary gains.

4. Linear regression. Using the file BUCJ59105CCHICAGOCCAS.SAV, Consider the relationship between motor vehicle theft rates and median income rates in the neighborhoods. You will use your own variable MVTHEFTRATE along with MEDIC.

Crime Rate 10

The trend line is downward sloping which means that neighborhoods with higher incomes are less likely to report a motor vehicle theft.

b. Write an equation for the regression model.

MVTHEFTRATE = 0.008 – 7.087E-008*MEDINC

c. Are the results statistically significant?

The p-value of t-stat and F-stat is close to zero which means that the results are statistically significant.

d. What does the R2 tell us? Why is it important?

The value of R2 at 0.314 tells that about 31.4% of the variation in MVTHEFTRATE can be explained by Medinc. It tells us about the goodness of fit of the model.

e. In a few sentences, interpret the results of your analysis. What policies would you recommend to city leadership to reduce motor vehicle theft in the city? Can you relate your findings to a theory from criminology?

The significant results conclude that neighborhoods with higher incomes are less likely to report a motor vehicle theft and vice versa. Moreover, about 31.4% of the variation in motor vehicle theft can be explained by the income variable.

Apart from increasing the opportunities for generating higher income for the population, we recommend creating policies and infrastructure for increased perception of the risk for the offenders which may help reduce motor vehicle theft in the city. These can be done using modern technologies like vehicle tracking, using GPS, number plate reading, and increased penalties and fines.

Many studies do suggest that motor vehicle theft crimes support rational choice theory and strain theory among others. Motor vehicle theft is done for different reasons like for monetary gains, usually, by older adults (rational choice theory), and for peer pressure usually by young adults (strain theory).