Determine the three-year total crime rate per institution separately for private and public institutions.

Case Analysis and Report
To complete this assessment use the Campus Crime Data Excel spreadsheet located in Resources. This file contains two data sheets:
The Campus Crime Data for Minnesota (20092011) page which provides actual data generated by the U.S. Department of Educations Campus Safety and Security Data Analysis Cutting Tool.
The Campus Crime Data Codebook which explains the labels used in the Campus Crime Data sheet.
Practical Application Scenario
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 three-year total crime rate in public institutions is higher than that in private institutions. They have asked you to test that hypothesis. Conduct the test and describe your results. To start you will:
Formulate the hypotheses statement.
Determine the three-year total crime rate per institution separately for private and public institutions.
Use the appropriate statistical approach to conduct and test the hypotheses for difference in crime rates.
Your clients would also like you to develop a 95 percent confidence interval for the difference in three-year 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?
Complete your report in a Word document (submitted as a .docx file) including 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.
Campus Crime Data for Minnesota (20092011)
UNITID_P INSTNM BRANCH Address City State ZIP sector_cd sector_desc men_total women_total total MURD9 NEG_M9 FORCIB9 NONFOR9 ROBBE9 AGG_A9 BURGLA9 VEHIC9 ARSON9 MURD10 NEG_M10 FORCIB10 NONFOR10 ROBBE10 AGG_A10 BURGLA10 VEHIC10 ARSON10 MURD11 NEG_M11 FORCIB11 NONFOR11 ROBBE11 AGG_A11 BURGLA11 VEHIC11 ARSON11 FILTER09 FILTER10 FILTER11
125231001 Walden University Academic Offices 100 Washington Avenue South Suite 900 MINNEAPOLIS MN 55401 3 Private for-profit 4-year or above 11131 37851 48982 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1
172866001 Academy College Main Campus 1101 E. 78th Street Suite 100 MINNEAPOLIS MN 554251554 3 Private for-profit 4-year or above 136 55 191 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 1 1 1
172918001 Alexandria Technical & Community College Alexandria Technical and Community College 1601 JEFFERSON ST ALEXANDRIA MN 56308 4 Public 2-year 1418 1352 2770 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1
172927001 American Indian OIC Inc American Indian OIC 1845 E. Franklin Ave Minneapolis MN 554042221 8 Private nonprofit less-than 2-year 24 137 161 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1
172954001 Anoka Technical College Anoka Technical College Main Campus 1355 W HWY 10 ANOKA MN 55303 4 Public 2-year 872 1517 2389 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 1
172963001 Anoka-Ramsey Community College Anoka-Ramsey Community College-Coon Rapids Campus 11200 MISSISSIPPI BLVD NW COON RAPIDS MN 55433 4 Public 2-year 3560 5674 9234 0 0 0 0 0 0 1 3 0 0 0 0 0 0 0 1 3 0 0 0 0 0 0 0 0 0 0 1 1 1
172963002 Anoka-Ramsey Community College ANOKA-RAMSEY COMMUNITY COLLEGE-CAMBRIDGE CAMPUS 300 Spirt River Drive South Cambridge MN 55008 4 Public 2-year 3560 5674 9234 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1
173045001 Augsburg College Main Campus 2211 RIVERSIDE AVE MINNEAPOLIS MN 55454 2 Private nonprofit 4-year or above 1603 2303 3906 0 0 1 0 1 0 14 3 0 0 0 0 0 0 0 15 3 0 0 0 1 0 0 0 11 0 0 1 1 1
173045002 Augsburg College Rochester Program 2619 NW 9th Ave. Rochester MN 55902 2 Private nonprofit 4-year or above 1603 2303 3906 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1
173063001 Riverland Community College Main Campus 1900 8TH Ave NW Austin MN 55912 4 Public 2-year 1755 1965 3720 0 0 0 0 0 0 4 2 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 1 0 0 1 1 1
173063002 Riverland Community College Albert Lea Campus 2200 Riverland Drive Albert Lea MN 56007 4 Public 2-year 1755 1965 3720 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1