To complete this assessment, use data analysis software and the Campus Crime Data Excel file. The...

Question

To complete this assessment, use data analysis software and the Campus Crime Data Excel file. The Excel file contains two data sheets:

The Campus Crime Data for Minnesota (2009–2011) page provides actual data generated by the U.S. Department of Education's Campus Safety and Security Data Analysis Cutting Tool. The Campus Crime Data Codebook explains the labels used in the Campus Crime Data sheet. Practical Application Scenario As a result of recent campus safety concerns at Loyola University, you have been engaged by campus security team leaders to gather and analyze data about on-campus crime rates in schools in the state of Minnesota. Crime data from 181 Minnesota campuses has been compiled in the Campus Crime Data file.

Write a management report for campus security team leaders analyzing and evaluating campus crime data for Minnesota. Include your findings and recommendations for your clients. In your report, be sure to examine the following:

Identify what crimes were most commonly committed on Minnesota campuses between 2009 and 2011. Based on the data, would you say the crime rates decreased or increased from 2009 to 2011? The campus security leaders believe that the total crime rate in public institutions is more than that in private institutions. They have asked you to test that hypothesis. Describe your results. Your clients would also like you to develop a 95 percent confidence interval for the difference in total campus crime rates between public and private institutions in Minnesota. Report your results. Analyze what ethical issues, if any, should concern you in conducting your research. Additional Requirements Compile your work and report in a 2–4 page Word document.

Include whatever relevant tables and graphics you need to support your findings. Place your tables and graphics within the text and be sure to clearly title them. Your tables and graphics must be legible and suitable for inclusion in a management report.

qfile_636779899979937764_123237_1.xls

Pooja · Accepted Answer

Question 1)
Table 1 Display of Number of Crimes Occurring within 2009-2011
	Crime
	Year
	Total
	
	2009
	2010
	2011
	
	Murder
	0
	0
	0
	0
	Neg
	0
	0
	0
	0
	Forci
	79
	66
	73
	218
	NonForc
	0
	0
	3
	3
	Robbery 
	12
	9
	16
	37
	AGG
	31
	24
	20
	75
	BurgA
	368
	291
	253
	912
	Vehic
	56
	50
	27
	133
	Arson
	8
	8
	10
	26
	Total
	554
	448
	402
	1404
Figure 1 Frequency Number of Crimes Occurring within 2009-2011
The most commonly committed crimes on Minnesota campuses between 2009 and 2011 is Burglary. Observed 912 (65%) Burglary cases among the total 1404 crimes occurring within 2009-2011. This can be seen with the reference of table 1 and figure 1. 
Figure 2 Total Number of Crimes Occurring in the Years 2009, 2010, and 2011
The crime rates are decreasing from year 2009 to year 2011. From 2009 to 2010 there is 19.1% decrease in the crime rate and from 2010 to 2011 the decrease is observed to be 10.3%.
Question 2)
There are two sector codes, i.e.

To complete this assessment, use data analysis software and the Campus Crime Data Excel file. The Excel file contains two data sheets: The Campus Crime Data for Minnesota (2009–2011) page provides...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment