Solved by verified expert:Analyze a provided data file for a scenario and write a 2–4
page management report detailing your findings and recommendations
based on the results.Note: The assessments in this course build upon each
other, so you are strongly encouraged to complete them in sequence.
assessment_9.doc
assessment_9_ci_calculator_v1.xlsx
cf_campus_crime_data_assessment_9.xls
cf_exemplar_mba_fp6018_assessment_9.pdf
Unformatted Attachment Preview
Data Analysis and Management
Analyze a provided data file for a scenario and write a 2–4 page management report detailing
your findings and recommendations based on the results.
Note: The assessments in this course build upon each other, so you are strongly encouraged to
complete them in sequence.
To complete this assessment, use data analysis software and the Campus Crime Data Excel file,
linked in the Resources under the Required Resources heading. The Excel file contains two data
sheets:
1. 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.
2. 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 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:
1. 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?
2. 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.
3. 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.
4. 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.
Reference
U.S. Department of Education. (n.d.). The campus safety and security data analysis cutting tool
[Data files]. Retrieved from http://ope.ed.gov/security/
Data Analysis and Management Scoring
Guide
Criteria
Analyze data to develop
conclusions that address
management concerns regarding
campus crime rates.
Proficient
Analyzes data to develop
conclusions that address
management concerns regarding
campus crime rates.
Distinguished
Evaluates data to
develop conclusions
that address
management
concerns regarding
campus crime rates,
and supports
statements with data.
Evaluates ethical
considerations in the
collection and
Analyze ethical considerations in Analyzes ethical considerations in analysis of
the collection and analysis of
the collection and analysis of
descriptive statistics
descriptive statistics data to
descriptive statistics data to
data to support
support decision making.
support decision making.
decision making;
supports statements
with relevant, realworld examples.
Compute a statistical test to
Computes a statistical test to
determine acceptance or rejection determine acceptance or rejection
of a null hypothesis.
of a null hypothesis.
Computes and
interprets a statistical
test to determine
acceptance or
rejection of a null
hypothesis.
Analyze a 95 percent confidence
interval solution using provided
data.
Analyzes a 95 percent confidence
interval solution using provided
data.
Analyzes and
interprets a 95
percent confidence
interval solution
using provided data,
and provides
recommendations in
a management
report.
Compile findings into a
management report with details
for recommended actions.
Compiles findings into a
management report with details
for recommended actions.
Compiles findings
into a management
report with details
Criteria
Proficient
Distinguished
for recommended
actions; presents
information in a
format expected of
the business
profession.
Communicates in a
manner that is
professional,
scholarly, and
Communicate in a manner that is Communicates in a manner that is consistent with
professional and consistent with professional and consistent with
expectations for
expectations for members of the expectations for members of the
members of the
business professions.
business professions.
business professions.
Adheres to APA
guidelines, and work
is appropriate for
publication.
CONFIDENCE INTERVAL CALCULATOR (last updated 24 March 2011)
This spreadsheet can be used to calculate confidence intervals for a mean, the difference betweeen two means,
a proportion or odds, comparisons of two proportions (the absolute risk reduction, number needed to treat,
relative risk, relative risk reduction and odds ratio), sensitivity, specificity and two-level likelihood ratios.
To use the calculator, click on the tabs at the bottom of this screen to choose the appropriate worksheet. Enter
the required data. The result will be returned under the Result heading. Note that the cells in the Results section
contain formulas, even though these cells initially appear blank. Be careful not to delete or overwrite the formulas
The confidence interval for the difference between two means uses the method that assumes equal variances for
the two populations (see Armitage P and Berry G (1994): Statistical Methods in Medical Research (3rd ed.).
London: Blackwell, pp 108-109).
The method used to calculate a confidence interval for a proportion is the Wilson score method without continuity
correction (see Newcombe RG (1998). Two-sided confidence intervals for the single proportion: Comparison of
seven methods. Statistics in Medicine , 17, 857-872).
The confidence limits for the odds were obtained by taking the confidence limits for the proportion and converting
those proportions into odds.
The method used to calculate a confidence interval for the difference between two proportions is the NewcombeWilson method without continuity correction (see Newcombe RG (1998). Interval estimation for the difference
between independent proportions: Comparison of eleven methods. Statistics in Medicine, 17, 873-890). The
confidence limits for the number needed to treat are the inverse of the limits for the absolute risk reduction.
Confidence intervals for the relative risk and odds ratios are calculated using the methods described by Armitage
and Berry (Armitage P and Berry G (1994): Statistical Methods in Medical Research (3rd ed.). London: Blackwell,
p 131). The relative risk reduction and its confidence limits are 1 minus the relative risk and its confidence limits.
Confidence intervals for sensitivity and specificity are produced with the Wilson score method (see above for
reference). Confidence intervals for positive and negative likelihood ratios are calculated with the method
described by Simel and colleagues (Simel DL, Samsa GP, Matchar DB (1991). Likelihood ratios with confidence:
sample size estimation for diagnostic test studies. Journal of Clinical Epidemiology , 44, 763-70). The confidence
interval for the diagnostic odds ratio is calculated as described by Armitage and Berry (see above for reference).
The results have been checked against worked examples in the sources cited above. Nonetheless there may still
be errors. If you identify errors please contact the author, Rob Herbert, email: r.herbert@neura.edu.au.
difference of 2 means
TO ESTIMATE A CONFIDENCE INTERVAL FOR THE DIFFERENCE BETWEEN TWO MEANS:
Enter the mean of the control group here:
Enter the estimated population standard deviation for the control group here:
Enter the sample size (eg, number of subjects) for the control group here:
Enter the mean of the experimental group here:
Enter the estimated population standard deviation for the experimental group here:
Enter the sample size (eg, number of subjects) for the experimental group here:
Enter the required confidence interval (eg, 95%) here:
95
RESULT
The estimated difference between the two population means is:
The estimated CI is:
CI Calculator Notes
1. Based on the results, we can be 95
2. Since the confidence interval includ
You need to provide a source
Utilize both an in-text citation and a
Page 2
difference of 2 means
FERENCE BETWEEN TWO MEANS:
Public Data
Private Data
CI Calculator Notes
1. Based on the results, we can be 95% confident that the mean difference between the crime rate in public and private institutions is b
2. Since the confidence interval includes the number 0, this indicates the difference in crimes between public and private institutions is n
You need to provide a source for the second statement to support the statement.
Utilize both an in-text citation and add the source to your reference list at the end of your paper.
Page 3
difference of 2 means
crime rate in public and private institutions is between -1.71 and 10.97
mes between public and private institutions is not statistically significant
Page 4
Campus Crime Data for Minnesota (2009–20
UNITID_P
125231001
172866001
172918001
172927001
172954001
172963001
172963002
173045001
173045002
173063001
173063002
173063003
173115001
173124001
173142001
173160001
173179001
173203001
173203002
173258001
173300001
173328001
173416001
173452001
173461001
173470001
173489001
173559001
173559002
173559003
173559004
173629001
173638001
173638002
173638003
173638004
173638005
173638006
173638009
173638010
173647001
173665001
173683001
173708001
INSTNM
Walden University
Academy College
Alexandria Technical & Community College
American Indian OIC Inc
Anoka Technical College
Anoka-Ramsey Community College
Anoka-Ramsey Community College
Augsburg College
Augsburg College
Riverland Community College
Riverland Community College
Riverland Community College
Northwest Technical College
Bemidji State University
Bethany Lutheran College
Bethel University
Bethel Seminary-St. Paul
Central Lakes College-Brainerd
Central Lakes College-Brainerd
Carleton College
Concordia College at Moorhead
Concordia University-Saint Paul
Dakota County Technical College
Martin Luther College
Lake Superior College
Cosmetology Careers Unlimited-Duluth
Duluth Business University
Minnesota State Community and Technical College
Minnesota State Community and Technical College
Minnesota State Community and Technical College
Minnesota State Community and Technical College
Globe University-Woodbury
Minnesota West Community and Technical College
Minnesota West Community and Technical College
Minnesota West Community and Technical College
Minnesota West Community and Technical College
Minnesota West Community and Technical College
Minnesota West Community and Technical College
Minnesota West Community and Technical College
Minnesota West Community and Technical College
Gustavus Adolphus College
Hamline University
Hazelden Graduate School of Addiction Studies
Hennepin Technical College
173708002
173726001
173735001
173744001
173799001
173805001
173887001
173896001
173902001
173911001
173911002
173920001
173920002
173939001
173957001
173966001
173984001
173993001
173993002
174020001
174066001
174066003
174075001
174118001
174127001
174136001
174154001
174190001
174206001
174233001
174251001
174279001
174321001
174358001
174358002
174376001
174385001
174394001
174428001
174437001
174473001
174473002
174482001
174491001
174507001
174525001
174534001
Hennepin Technical College
Cosmetology Careers Unlimited-Hibbing
Hibbing Community College-A Technical and Community College
Aveda Institute-Minneapolis
Inver Hills Community College
Itasca Community College
The Art Institutes International-Minnesota
Luther Seminary
Macalester College
South Central College
South Central College
Minnesota State University-Mankato
Minnesota State University-Mankato
Regency Beauty Institute-Blaine
Mayo Medical School
Mayo School of Health Sciences
Argosy University-Twin Cities
Mesabi Range Community and Technical College
Mesabi Range Community and Technical College
Metropolitan State University
University of Minnesota-Twin Cities
University of Minnesota-Twin Cities
University of Minnesota-Crookston
Minneapolis Business College
Minneapolis College of Art and Design
Minneapolis Community and Technical College
Herzing University-Minneapolis
Minnesota School of Cosmetology
Crossroads College
University of Minnesota-Duluth
University of Minnesota-Morris
Minnesota School of Business-Richfield
Model College of Hair Design
Minnesota State University Moorhead
Minnesota State University Moorhead
North Hennepin Community College
National American University-Roseville
Brown College-Mendota Heights
Normandale Community College
North Central University
Northland Community and Technical College
Northland Community and Technical College
Northwest Technical Institute
Northwestern College
Northwestern Health Sciences University
Oak Hills Christian College
Regency Beauty Institute-Burnsville
174570001
174604001
174738001
174747001
174756001
174765001
174783001
174792001
174817001
174817002
174844001
174862001
174899001
174899002
174899003
174899004
174899005
174914001
174914002
174914004
174932001
174978001
175005001
175005002
175014001
175014002
175014003
175014004
175014005
175014006
175014007
175041001
175078001
175120001
175139001
175157001
175227001
175236001
175236002
175263001
175263002
175272001
175272002
175281001
175315001
365426001
367194001
Pine Technical College
Rainy River Community College
Rochester Community and Technical College
College of Saint Benedict
St Cloud Technical and Community College
Regency Beauty Institute-Waite Park
Saint Cloud State University
Saint Johns University
Saint Mary’s University of Minnesota
Saint Mary’s University of Minnesota
St Olaf College
Crown College
The College of Saint Scholastica
The College of Saint Scholastica
The College of Saint Scholastica
The College of Saint Scholastica
The College of Saint Scholastica
University of St Thomas
University of St Thomas
University of St Thomas
College of Visual Arts
Empire Beauty School-Bloomington
St Catherine University
St Catherine University
Rasmussen College-Minnesota
Rasmussen College-Minnesota
Rasmussen College-Minnesota
Rasmussen College-Minnesota
Rasmussen College-Minnesota
Rasmussen College-Minnesota
Rasmussen College-Minnesota
Saint Paul College-A Community and Technical College
Southwest Minnesota State University
Summit Academy Opportunities Industrialization Center
United Theological Seminary of the Twin Cities
Vermilion Community College
Dunwoody College of Technology
Ridgewater College
Ridgewater College
Minnesota State College-Southeast Technical
Minnesota State College-Southeast Technical
Winona State University
Winona State University
William Mitchell College of Law
Century Community and Technical College
Mayo Graduate School
McNally Smith College of Music
374024001 Adler Graduate School
380368001 Fond du Lac Tribal and Community College
407285001 Minnesota School of Business-Brooklyn Center
413413002 Capella University
413626001 Leech Lake Tribal College
417600001 Hastings Beauty School
430050001 Anthem College-Minnesota
434751001 White Earth Tribal and Community College
436483001 National American University-Bloomington
440767001 National American University-Brooklyn Center
440767002 National American University-Brooklyn Center
440800001 Miami Ad School-Minneapolis
442578001 Minnesota School of Business-Plymouth
443979001 PCI Academy
445081001 ITT Technical Institute-Eden Prairie
445221001 Regency Beauty Institute-Maplewood
445382001 Everest Institute-Eagan
445407001 DeVry University-Minnesota
445504001 Empire Beauty School-St Paul
445920001 Minnesota School of Business-Waite Park
445939001 Minnesota School of Business-Shakopee
446002001 American Academy of Acupuncture and Oriental Medicine
446844001 Le Cordon Bleu College of Culinary Arts-Minneapolis
447342001 Regency Beauty Institute-Minnetonka
447670001 Minnesota School of Business-Rochester
449214001 Regency Beauty Institute-Duluth
451769001 Minnesota School of Business-Blaine
453570001 Empire Beauty School-Eden Prairie
454616001 Institute of Production and Recording
455585001 Minnesota School of Business-Moorhead
456135001 Empire Beauty School-Spring Lake Park
456782001 Minnesota School of Business-Elk River
456834001 Globe University-Minneapolis
456959001 University of Minnesota-Rochester
457651001 CenterPoint Massage and Shiatsu Therapy School and Clinic
457679001 Avalon School of Cosmetology
458742001 Minnesota School of Business-Lakeville
459426001 Nova Academy of Cosmetology
460561001 Park Avenue School of Cosmetology
461546001 Rochester School of Hair Design
470870001 ITT Technical Institute-Brooklyn Center
474881001 Minneapolis Media Institute
475291001 Brown College-Brooklyn Center
End of Worksheet
Crime Data for Minnesota (2009–2011)
BRANCH
Academic Offices
Main Campus
Alexandria Technical and Community College
American Indian OIC
Anoka Technical College Main Campus
Anoka-Ramsey Community College-Coon Rapids Campus
ANOKA-RAMSEY COMMUNITY COLLEGE-CAMBRIDGE CAMPUS
Main Campus
Rochester Program
Main Campus
Albert Lea Campus
Owatonna College and University Center
Northwest Technical College
Bemidji State University
(Main Campus) Bethany Lutheran College
Bethel University – Main Campus
Bethel University – Main Campus
Brainerd Campus
Staples Main Campus
Carleton College
Concordia College
Main Campus
Main Campus
Main Campus
Trinity Road Campus
Main Campus
Duluth Business University
Main Campus – M State Fergus Falls campus
M State – Detroit Lakes campus
M State – Moorhead Campus
M State – Wadena Campus
Globe University – Woodbury
Minnesota West-Granite Falls Campus
Minnesota West-Worthington Campus
Minnesota West-Canby Campus
Minnesota West-Pipestone Campus
Minnesota West-Jackson Campus
Minnesota West – Fairmont Site
Minnesota West – Luverne Center
Redwood Falls Learning Center
Gustavus Adolphus College
Main Campus
Main Campus
Main campus
Address
100 Washington Avenue South, Suite 900
1101 E. 78th Street, Suite 100
1601 JEFFERSON ST
1845 E. Franklin Ave
1355 W HWY 10
11200 MISSISSIPPI BLVD, NW
300 Spirt River Drive South
2211 RIVERSIDE AVE
2619 NW 9th Ave.
1900 8TH Ave NW
2200 Riverland Drive
965 Alexander Dr SW
905 GRANT AVE SE
1500 BIRCHMONT DR NE
700 LUTHER DR
3900 BETHEL DR
3949 BETHEL DR
501 WEST COLLEGE DRIVE
1830 Airport Road
One North College Street
901 S 8TH ST
1282 Concordia Avenue
1300 E 145TH ST
1995 LUTHER CT
2101 TRINITY RD
121 W SUPERIOR ST
4724 Mike Colalillo Drive
1414 COLLEGE WAY
900 HWY 34 E
1900 28TH AVE S
405 SW COLFAX AVE BOX 566
8089 Globe Drive
1593 11th Avenue
1450 Collegeway
1011 First Street West
1314 North Hiawatha Avenue
401 West Street
115 South Park Street
311 North Spring Street
403 South Mill St
800 West College Avenue
1536 HEWITT AVENUE
15251 Pleasant Valley Rd
9000 Brooklyn Blvd
Eden Prairie
Main Campus
Main Campus
Main Campus
Main Campus
Main Campus
The Art Institutes International Minnesota
Luther Seminary
Main Campus
North Mankato Campus
Faribault Campus
Main Campus
Minnesota State University, Mankato at Edina
REGENCY BEAUTY INSTITUTE
Main Campus
Main Campus
Argosy University – Twin Cities
MESABI RANGE COMMUNITY & TECHNICAL COLLEGE – Virginia
MESABI RANGE COMMUNITY AND TECHNICAL COLLEGE
Main Campus
Main Campus
Saint Paul
Crookston Campus
Main Campus
Main Campus
Main Campus
Main Campus
Minnesota School of Cosmetology – Woodbury
Crossroads College
University of Minnesota Duluth
U OF M, MORRIS
Minnesota School of Business – Richfield
Model College of Hair Design
Main Campus
Regional Science Center
Main Campus
NAU-Roseville
Main Campus
Main Campus
North Central University
Thief River Falls
East Grand Forks
Main Campus
Main Campus
Main Campus
Oak Hills Christian College
REGENCY …
Purchase answer to see full
attachment
