# Campus Safety Analysis: Capella University

1217 Words5 Pages
MBA 6018
Ryan Smith
Unit 6 Assignment 1
7/3/15

Campus Safety Analysis, Minnesota – Prepared for Capella University
Due to recent concerns from the Capella University Security team, their recommendation is to analyze data from crime rates on Minnesota College campuses, to understand crime trends, and reduce occurrences on campus. To gain insight on crime rates, data was pooled from the U.S. Dept. of Education’s website on Campus Crime. This data will be utilized to examine the following questions from the security team:
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
Although the standard deviation is large between numbers in the data set, which increases the standard error rate, The Test shows at all levels of α, evidence that supports the client’s belief that Public Institutions have a mean crime rate that is larger than the mean crime rate at Private Institutions.
3. A confidence interval was requested, at a 95% level for the difference in total campus crime rates between public and private institutions in Minnesota. Utilizing the information in Table 2, summarized from the Sample Data for all colleges in Minnesota, a Confidence interval for the crime rates for Public, and for Private institutions was calculated below.
a. Confidence Interval – Public Institutions
Input Variables -- Public Institutions

Sample Mean (x-bar)
10.67

Sample standard deviation (s):
21.45

Sample Size (n)
67

Confidence Level:
0.95

Intermediate Calculations --

Degrees of freedom:
66

Standard Error of the Estimate:
2.6205346

Prob. in the tails for this Conf Level:
0.05

t-Multiple:
1.9965644

Lower limit:
5.4379339

We can be 95% confident that the population mean
Upper limit:
15.90

lies between 5.44 and 15.9
Margin of error:
5.23

b. Confidence Interval – Private Institutions
Input Variables --

Sample Mean (x-bar)
6.04

Sample standard