Homework SourseFor this Application Assignment perform a crosstabulation on
For this Application Assignment, perform a cross-tabulation on the data provided in the handout “Week 10 Dataset” such that property crime is displayed as a rate per student population. Though Excel is not the only software that can be used to perform a cross-tabulation, it is used here because it is a widely available program. The handout entitled, “Cross-Tabulation in Excel” contains instructions on how to complete the task in Excel using two different methods.
| College | Student Enrollment | Crime Total | Forcible Rape | Aggravated Assault | Arson | Property Crime |
| Abalone University | 10,486 | 35 | 5 | 12 | 1 | 17 |
| Franklinville College | 989 | 4 | 0 | 2 | 0 | 2 |
| Marie Louis College | 2,301 | 14 | 2 | 4 | 0 | 8 |
| Robert Long College | 3,467 | 9 | 0 | 1 | 0 | 8 |
| Simon State | 20,573 | 42 | 3 | 5 | 1 | 33 |
Solution
Can be done using pivot table. Property crime rate is .0016 per student or 1.6 property crimes per thousand student.
| Row Labels | Sum of Student Enrollment | Sum of Property Crime | |
| Abalone University | 10486 | 17 | 0.0016 |
| Franklinville College | 989 | 2 | 0.0016 |
| Marie Louis College | 2301 | 8 | 0.0016 |
| Robert Long College | 3467 | 8 | 0.0016 |
| Simon State | 20573 | 33 | 0.0016 |
| Grand Total | 37816 | 68 |
