Download the Tempe calls for service data from their Open Data Website. You can find it here: https://data.tempe.gov/dataset/police-calls-for-service (Links to an external site.) This data does not come with a codebook. While that might not be a problem if youre already a police officer or dispatcher, the rest of us are going to need some labels. Download the translation tables here from Canvas. Theres more than one way that connect the labels to the data, but were going to use SPSS for this one. Why SPSS? If a law enforcement agency has a statistical package, its most likely to be SPSS. Download the sample data cleaning code here from Canvas. Open SPSS. Import the calls for service (cfs) data from Excel. Import the various translation tables from excel. You can do this using the sample data cleaning code, but youll need to adjust the syntax to your own file pathways. Apply the labels using the cleaning syntax. Select only cases from 2016, 2017, and 2018 using the cleaning syntax. Answer these questions on the screen as you do your screen cast so that I can see them easily: How many calls for service (cfs) were in the original dataset? How many cfs occurred in 2017? What are the labels for how calls are cleared? Looking at these, should we exclude any more cases? Why or why not? Should we include all call types? Why or why not? Export your data from SPSS back to Excel so that we can use it later . https://cdn.inst-fs-iad-prod.inscloudgate.net/9aa161f6-f6d3-4a8f-97b5-fd71a807223e/Tips%20for%20importing%20and%20exporting%20data%20in%20SPSS.mp4?token=eyJhbGciOiJIUzUxMiIsInR5cCI6IkpXVCIsImtpZCI6ImNkbiJ9.eyJyZXNvdXJjZSI6Ii85YWExNjFmNi1mNmQzLTRhOGYtOTdiNS1mZDcxYTgwNzIyM2UvVGlwcyUyMGZvciUyMGltcG9ydGluZyUyMGFuZCUyMGV4cG9ydGluZyUyMGRhdGElMjBpbiUyMFNQU1MubXA0IiwidXNlcl9pZCI6IjcyMzYwMDAwMDAwMTAzNjkzIiwiaWF0IjoxNTcwMDIzNDE1LCJleHAiOjE1NzAxMDk4MTV9.hZswXe6Q-y1hKcO0JPUPDOFY93UTkgJGJbrIGwi_S-JPkkFYRV3x4x2bE_rEfk6KFt_aiS24FuElYsm51ggkMA&download=1&content_type=video%2Fmp4
