Case Analysis and Report RTo complete this assessment, use the Campus Crime Data

Question

Case Analysis and Report

RTo 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 (2009–2011) page, which 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, 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?

Explanation / Answer

once you have the crime rates for private and public institutions separately then you can conduct a equality of proportio test. Let p1 and p2 be the crime rates for private and public institutions respectively then we can test the hypothesis that :

H0 : p1=p2 vs H1 : p1 < p2 ( according to the belief)

and let p1hat and p2hat be the sample proportion of crime rates in private and public institution respectively. then under H0 both will follow a binomial distribution with common parameter p1=p2=p . Then the usual equality of proportion test with test statistic following a hypergeometric distribution can be constructed. Or else you can adopt large sample procedure. if the sample sample size is high then p1hat - p2hat will asymptotically follow a normal distribution with mean p1-p2 and variance is the sum of var(p1hat ) + var(p2hat). Then usual Z statistic test can be constructed to test the hypothesis at 5% level of significance and conclude upon the result.

Thanks!!!!! Have the data and just follow the procedure.......

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.