Management Assessment Unit 6

Management Assessment

  • Toggle DrawerIntroductionIn 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 DrawerUnit ResourcesSuggested ResourcesThe 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 SoftwareTo 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 from
      • 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.
    ReadingTextbook: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 ResourcesThe following resources are available online:TutorialsStatisticsLectures:The following recommended tutorials are from Note: Use the URLs from the citations below to access and complete these tutorials.Course Library GuideA 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 DrawerQuestions to ConsiderAs 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 DescriptionAssessment ContextBy 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 InstructionsTo 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 ScenarioAs 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.