In Class Assignment1 and 2
Name ______
Code ______
The following spreadsheet is one month worth of burglary data from the Osceola County Sheriff's Office. Please carefully examine the spreadsheet, namely the nature of the data and perform the following steps.
Previewing the Data
1) What kind of data is represented in this workbook?______
2) How many worksheets are in the workbook?______
3) How many columns are in the workbook?______
4) How many incidences occurred in Florida?______
5) How many incidences did not?______
6) How many of the total number of December burglaries occurred in Kissimmee?______
7) How many of the total number of December burglaries occurred in Poinciana?______
8) What is the date range of burglaries that occurred in December in OsceolaCounty?______
9) What is the date range of burglaries dispatches that occurred in December in ______
OsceolaCounty?
10) Do all burglary dispatch dates correspond with the time that the incidence occurred? ______
11) If they do not correspond, speculate as to why? Be detailed. You may want to research such a problem on the internet or refer to class notes.
______
______
______
______
______
______
______
______
______
______
______
______
______
______
______
12) What proportion of burglary incidences in OsceolaCounty in December of ______
were alarm calls?
Formatting/Cleaning/Calculating
1) Bold all column headings on the DecBurg worksheet and title it accordingly?
2) Insert a new worksheet and title it BurgTotl.
3) Create the following column headings in the new worksheet - (1) Offense Type, (2) Count
a.Bold the column headings.
b.Change column heading font sizes to 14.
4) Add the following offense types to the spreadsheet (below the Offense Type column heading)
a.Burglary alarm
b.Conveyance burglary
c.Motel burglary
d.Residential burglary
e.Total burglaries
5) Insert a new row below Burglary Alarm and type Business burglary.
a.bold all row headings (offense types).
b.Change the Total Burglaries row heading to red font.
6) Clean up any other data problems you have found in the spreadsheet. Do your best with problems you encounter. Be sure to attach an additional sheet noting all problems and how you corrected these problems (formulas, functions, manual manipulation techniques……)
7) From the DecBurg worksheet, determine the number/count of each offense type and enter that number in the
BurgTotl spreadsheet in its respective count column.
8) How many residential burglaries occurred in OsceolaCounty in December2004? ______
9) How many business burglaries occurred in OsceolaCounty in December2004? ______
10) How many conveyance burglaries occurred in OsceolaCounty in December2004? ______
11) How many total burglaries occurred in OsceolaCounty in December2004? ______
12) What formula did you use to calculate the total number of offenses? ______
13) Identify 2 temporal relationships in these data. Identify the variables used and the relationships identified. Speculate as to why the pattern you discover in these data may exist.
14) Identify 2 spatial relationships in these data. Identify the variables used and the relationships identified. Speculate as to why the pattern you discover in these data may exist.
15) Identify one spatial/temporal relationship in these data. Identify the variables used and the relationship identified. Speculate as to why the pattern you discover in these data may exist.
16) Identify (1) at least 3 data problems with these data as you can and (2) Discuss the ramifications of the identified data problems. Use the following format and use the back of this assignment as necessary.
Problem 1: ______; Discuss Issue 1:
Problem 2: ______; Discuss Issue 2: