For this Application Assignment, perform a cross-tabulation on the data provided

Question

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

Explanation / Answer

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

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---