0.243323 0.021571 0.868158 0.362864 0.536043 0.469131 0.477473 0.71328 0.122933 0.924694 0.298928 0.079328 0.189213 0.770563 0.607978 CHAPTER 5 SAMPLING The purpose of these case studies is to demonstrate your ability to develop both simple and stratified random sampling procedures in a realistic organizational scenario. You may refer to Chapter 5-R as needed, or to any other source. Assume that you are an entry level analytics professional and that your proposed procedures will be evaluated by the CEO of a small company. Case Study 5.1 Refer to the Basic Data Set file from Canvas. This file is a list of people in a hypothetical company and data referring to each person. Your organization has designated you to design a process to fairly select six people per month for random testing for illegal drug usage. Based on using this data set, and using the Excel random number generator, design a step-by-step procedure that will sample six employees without bias (i.e., based solely on random numbers) each month; use simple random sampling. Write the procedure, to include screen shots of examples, in a way that could be easily copied and pasted into a memo format for signature of the organization’s CEO. Case Study 5.2 Refer to the Basic Data Set file from Canvas. This file is a list of people in a hypothetical company and data referring to each person. Your organization has designated you to design a process to fairly select six people per month for random testing for illegal drug usage. Based on using this data set, and using the Excel random number generator, design a step-by-step procedure that will sample six employees without bias (i.e., based solely on random numbers) each month. For this sampling process, stratify the sampling by gender to address the perception among some in the company that one gender has been selected more often than expected in past selections based on simple random sampling. Write the procedure, to include screen shots of examples, in a way that could be easily copied and pasted into a memo format for signature of the organization’s CEO. CASE STUDIES: CHAPTER 5 GRADING RUBRIC Student name: Each bullet requirement is worth 2 points each.  Does the procedure provide that each company employee has the same chance of being selected each month. _____  Is the procedure somehow based on using the Excel random number generator. _____  Is there a written procedure, suitable for copying and pasting into a memo to be written by the company CEO, for how the selection process works and why it is unbiased. _____  Does the written procedure include screen shots from the Excel Basic Data file taken during the selection procedure. _____
Purchase answer to see full attachment