As a result of recent campus safety concerns at Capella University, you have bee
ID: 3378541 • Letter: A
Question
As a result of recent campus safety concerns at Capella 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: 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. What, if any, ethical issues should concern you in conducting your research?
Explanation / Answer
Answer question
From the graph, it is much clear that among sampled college campuses, burglary was most commonly occurring crime (912) followed by forcible sex offense (218) and Motor vehicle theft (133).
During 2009 the mean crime rate was 3.06 and during 2011 this was found to be 2.22 per campus. In order to test the statistical significance of this reduction in mean crime rate paired sample t-test was conducted. Paired sample t-test revealed that there is significant decrease in crime rate from 2009 to 2001 (t= 2.4992, df=180, p=0.006).
t-Test: Paired Two Sample for Means
2009
2011
Mean crime rate/Year
3.060773481
2.220994475
Variance
80.32406384
34.11755678
Observations
181
181
Pearson Correlation
0.897873744
Hypothesized Mean Difference
0
df
180
t Stat
2.499273681
P(T<=t) one-tail
0.006670019
t Critical one-tail
1.653363014
P(T<=t) two-tail
0.013340039
t Critical two-tail
1.973230782
Hence we can say that there is significant decrease in crime rate during 2011 as compared to year 2009.
t-Test: Two-Sample Assuming Unequal Variances
Private Institutes
Public Institutes
Mean
2423.54386
6676.19403
Variance
35514241.49
79087139.01
Observations
114
67
Hypothesized Mean Difference
0
df
101
t Stat
-3.481648523
P(T<=t) one-tail
0.00036883
t Critical one-tail
1.660080631
P(T<=t) two-tail
0.00073766
t Critical two-tail
1.98373095
Comparison of grand total crime rate for public and private institutions reveal that mean total crime rate in case of public institutions is significantly greater than the mean total crimes per campus for private institutions (t=-3.48, p= 0.0003)
Hence we accept the hypothesis that mean crime rate in case of public institutions is greater than mean crime rate of private institutes.
95% confidence interval of difference between mean crime rates for private and public institutions is
1829.71 to 6675.58
t-Test: Paired Two Sample for Means
2009
2011
Mean crime rate/Year
3.060773481
2.220994475
Variance
80.32406384
34.11755678
Observations
181
181
Pearson Correlation
0.897873744
Hypothesized Mean Difference
0
df
180
t Stat
2.499273681
P(T<=t) one-tail
0.006670019
t Critical one-tail
1.653363014
P(T<=t) two-tail
0.013340039
t Critical two-tail
1.973230782
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.