LAB 4

Sheet1

LAB 4
Q1: Calculate Percentage of Offenses in the table below (all highlighted cells should be complete)
Most Serious Arrest Charge	f	%
Violent Offense	15, 938
Property Offense	12,441
Drug Offense	17,220
Public-Order Offense	7,504
	n=53,103
Q2: Using the data below, create a pie chart. Please label your chart as Most Serious Offense			Place pie chart in this area
Most Serious Arrest Charge	%
Violent Offense	30.01
operty Offense	23.43
Drug Offense	32.43
Public-Order Offense	14.13
	100
Q3: Create Bar Chart using the data below, label your bar chart as Offense Type
					Place bar chart in this area
Offense Type
Burglary	1191
Larceny/Theft	901
Motor Vehicle Theft	329
Forgery	194
Fraud	256
Other Property Offense	365
	N=3236
Q4: Have wiretap authorizations been increasing over time? Create a line chart to show a visual representation of this. Label your line chart as Wiretap Authorizations
Year	Amount
1997	1186
1998	1329				Place Line chart in this area
1999	1350
2000	1190
2001	1491
2002	1358
2003	1442
2004	1710
2005	1773
2006	1839
Q5: Create a histogram for the total number of traumatic experiences officers have experienced. Label your histogram as Total Number of Traumatic Experiences. Note: You should only have three bins (columns) (reference video in the module)
Participant	Total number of traumatic experiences
1	10
2	0
3	8
4	2				Place Histogram in this area
5	0
6	4
7	8
8	5
9	7
10	7
11	2
12	3
13	5
14	3
15	5
16	4
17	8
18	8
19	10
20	2