Using Excel, perform a cross tabulation on the data provided in the Week 10 dataset such that property crime is displayed as a rate per student population. 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.) I need to display the variable of property crime as a rate per student population and to explain the nature and significance of their relationship if any. Also which is the independent and which is the dependent variable?
Attachment:- 267431_1_Wk-10-dataset-W-research.xls