excel cross tabulation

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.

The assignment (2–3 pages):

• Using Excel, perform a cross tabulation on the data provided in the Week 10 dataset.
• Explain what you can conclude from the output of the cross tabulation.
• Include your outputs in your Application Assignment document. (Copy and paste them from Excel into your Word doc.)

Support your Application Assignment with specific references to all resources used in its preparation. You are to provide a reference list for all resources, including those in the Learning Resources for this course.