Enter the data for criminal offenses in 2005 and 2009 into an Spreadsheet.

2005		2009
type of Offense	No. of Suspects	Type of Offense	No. of Suspects
Violent	5,485	Violent	5,463
Property	25,570	Property	26,161
Drug	40,038	Drug	37,721
Public Order	21,583	Public order	23,067
Weapon	13,689	Weapon	11,749
Immigration	26,559	Immigration	88,313

1. Calculate the range for both years. Label the cell to left of your calculation so I know which values are the range.

2. Calculate the IQV for each year. Show your work, i.e. show me the additional column you need for each calculation. Show the IQV for each year in your spreadsheet.

3. Based on the range, which year showed more variability in the number of suspects?

4. Based on the IQV, which year showed more variability in the number of suspects?

Answer rating: 100% (QA)

1 Calculation of the range for both years Label the cell to left of your calculation of percentages ... View the full answer