Open the Police Report Data Entry Tutorial (below this dropbox). Follow along with the steps, and then complete the Excel spreadsheet for all 10 of the police reports on our textbook website. Here ar

Open the Police Report Data Entry Tutorial (below this dropbox). Follow along with the steps, and then complete the Excel spreadsheet for all 10 of the police reports on our textbook website. 

Here are the variables you need:

1. Incident report number
2. Beat
3. Offense
4. Street Number, Street Name
5. Occurred From Date (note that you need to separate out date and time here and below)
6. Occurred From Day (you need to determine this using the date and an old calendar, here and below)
7. Occurred From Time
8. Occur to Date
9. Occurred To Day
10. Occur to Time
11. Point of Entry, M.O.
12. Location
13. Items Taken
14. Vehicle Year Make

In the second sheet in this same Excel file, create a codebook. Your codebook will contain 16 rows: one row for the column headings (e.g., Variable Name and Variable Definition), one row for incident report number, and 14 rows for the 14 variables you code from the daily bulletins. For each variable, provide these pieces of information: variable name and variable definition.