Enter the data for criminal offenses in 2005 and 2009 into an Excel Spreadsheet. You will want
Question:
Enter the data for criminal offenses in 2005 and 2009 into an Excel Spreadsheet. You will want each in their own column, with the labels to the left.
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 |
Calculate the range for both years. Label the cell to left of your calculation so I know which values are the range.
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.
In a Word document, answer the following:
Based on the range, which year showed more variability in the number of suspects?
Based on the IQV, which year showed more variability in the number of suspects?