2024 – Management Assessment Toggle Drawer Introduction In this unit you will integrate the tools and techniques

Management Assessment

• Toggle Drawer
  

  Introduction

  In this unit, you will integrate the tools and techniques covered in the course by completing a data analysis. You will identify the data analyses needed to address a business problem and perform the appropriate data analyses. Finally, you will use the results of the analyses to prepare a report with management recommendations for action.

• Toggle Drawer
  

  Unit Resources

  Suggested Resources

  The following optional resources are provided to support you in completing each assessment. They provide helpful information about the topics in this unit. For additional resources, refer to the Research Resources and Supplemental Resources in the left navigation menu of your courseroom.

  Data Analysis Software

  To complete the assessments in this course, you will need to perform complex statistical functions, such as regressions, histograms, analysis of variance (ANOVA), and t-tests. You are strongly encouraged to use a data analysis software tool, such as Microsoft Excel Analysis ToolPak or StatPlus:mac (for Mac users) to complete your assessments accurately.

  • Microsoft Excel Analysis ToolPak Activation for PC Users: The Microsoft Excel Analysis ToolPak is a specialized Excel add-on included in the standard Microsoft Office suite. If your Excel software meets the standard Capella University Computer Requirements, you will not need to purchase this software. However, you may need to activate the application before you can use it. Read the Analysis ToolPak Activation guide for step-by-step installation instructions. Note:These instructions are designed for Microsoft Office 2007. If you are using a different version of Microsoft Office, you can search the Microsoft Office Web site for version-specific activation instructions. Use the following search terms: Excel analysis ToolPak activation instructions (your version).
  • StatPlus: mac LE Download for Mac Users: StatPlus:mac is a statistical software tool from AnalystSoft, which is compatible with Excel 2008 and 2011. If you use a Mac and you do not already have this software installed, you can download a 30-day free trial version from AnalystSoft.
    • AnalystSoft, Inc. (2011). StatPlus:mac LE. Retrieved fromhttp://www.analystsoft.com/en/products/statplusmacle/
    • Important Note:The free download available at AnalystSoft will be available for only 30 days. If necessary, you will probably be able to complete the assessments for the first three units of this course simply by using Excel. You may find it best to wait until Unit 4 or later to download this trial version.

  Reading

  Textbook:You may wish to refer to the FCHow Do I Find Books? library guide to explore options for acquiring this resource free of charge, or you may wish to purchase it from your preferred retailer.

  • Capella University (Eds.). (2011). MBA6018 – Data analysis for business decisions [Custom textbook]. New York, NY: McGraw-Hill. ISBN: 9780697804624.
    • Note:This custom textbook is available for purchase from the Capella University Bookstore. It contains a selection of readings originally published by McGraw-Hill in other contexts.

  Internet Resources

  The following resources are available online:

  • U.S. Department of Education. (2012). The campus safety and security data analysis cutting tool [Data files]. Retrieved from http://ope.ed.gov/security/
  • Hall, R. (1998). Between subjects one-way ANOVA example. Psychology World. Retrieved fromhttp://web.mst.edu/~psyworld/anovaexample.htm
  • Elliot, A. C. (2012). ANOVA using Microsoft Excel: One-way analysis of variance. Tutorials for Statistical Data Analysis. Retrieved from http://www.stattutorials.com/EXCEL/EXCEL_ANOVA.html

  Tutorials

  StatisticsLectures:The following recommended tutorials are from StatisticsLectures.com. Note: Use the URLs from the citations below to access and complete these tutorials.

  • StatisticsLectures.com. (Producer). (2012). Confidence intervals for the difference of two proportions[Video]. Available from http://www.statisticslectures.com/topics/ciproportions/
    • For an accessible version of this tutorial, click Transcript.
  • StatisticsLectures.com. (Producer). (2012). Confidence intervals for independent samples t-test [Video]. Available from http://www.statisticslectures.com/topics/ciindependentsamplest/
    • For an accessible version of this tutorial, click Transcript.

  Course Library Guide

  A Capella University library guide has been created specifically for your use in this course. You are encouraged to refer to the resources in the MBA-FP6018 – Data Analysis for Business Decisions Library Guide to help direct your research.

• Toggle Drawer
  

  Questions to Consider

  As you complete the assessment work in this unit, you may find it helpful to consider the questions below. You are encouraged to discuss them with a fellow learner, a work associate, an interested friend, or a member of the business community, in order to deepen your understanding of the topics.

  The term, inference, refers to parameter estimation and hypotheses testing. Hypothesis testing could be conducted based on the p-value (critical value), or based on construction of confidence intervals.

  • Are you confident in making inferences for business decisions based on confidence interval and p-value (or critical value) approaches?
  • How would you use the confidence interval approach to make inferences for business decisions, based on the difference between two population rates?
  • Do you have a preference between the two approaches for making statistical decisions to support business strategy? If so, why?
• Toggle Drawer
  

  [u06a1] Data Analysis and Management Description

  Assessment Context

  By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:

  • Competency 1: Identify, organize, and assess data for use in business decisions.
    • Analyze data to develop conclusions that address management concerns regarding campus crime rates.
    • Analyze ethical considerations in the collection and analysis of descriptive statistics data to support decision-making.
  • Competency 2: Analyze business decision opportunities using descriptive statistics.
    • Compute a statistical test to determine acceptance or rejection of a null hypothesis.
    • Analyze a 95 percent confidence interval solution using provided data.
  • Competency 6: Communicate in a manner that is professional and consistent with expectations for members of the business professions.
    • Communicate in a manner that is professional and consistent with expectations for members of the business professions.

  Assessment Instructions

  To complete this assessment, use the Campus Crime Data Excel file, linked in the Assessment Resources. This 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. 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. What, if any, ethical issues should concern you in conducting your research?

  Complete your report in a Word document, pasting in 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.