Simple Random Sampling Case Study & Worksheet

User Generated

U2690

Business Finance

Description

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 INSTRUCTIONS AND RUBRIC ATTACHED)

--- To use the random formula and assign random numbers between 0 and 1 to the items in the Basic Data Set, use the formula: = RAND() in the corresponding excel cell.

--- Move the cursor (mouse) to the end of the cell to take the shape of a cross and drag it down to populate the formula across the column/rows corresponding to the values in Excel Sheet.

--- After that, highlight the column and sort in some manner (remember it is random selection) either from the smallest or highest. Then proceed to select by an additional criteria after the sorting.

--- During this take some screenshots to document the process you are describing. - The second exercise is similar to the first with an additional step. (Random formula attached)

Unformatted Attachment Preview

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. _____ Name Echo Mike Oscar Romeo Alpha Delta Foxtrot Kilo Lima November Quebec Tango Uniform Victor Whiskey Xray Juliet Sierra Hotel Papa Yankee India Zulu Bravo Charlie Golf Title Ms. Ms. Mr. Ms. Mr. Mr. Ms. Mr. Ms. Mr. Ms. Ms. Mr. Mr. Ms. Mr. Ms. Ms. Ms. Ms. Mr. Ms. Ms. Ms. Mr. Ms. Employee ID 29584 12037 62958 73891 96572 96689 27981 19547 49776 47389 34441 49040 51585 44791 76744 31811 82912 31684 24581 10641 26138 47611 53729 96491 76850 13302 Job Series Finance/Accounting Finance/Accounting Finance/Accounting Finance/Accounting CEO Software Development Software Development Software Development Software Development Software Development Software Development Software Development Software Development Software Development Software Development Software Development IT IT Sales Finance/Accounting Software Development Sales Sales CIO CFO Analytics Salary in $1000 $62 $47 $48 $49 $155 $56 $45 $24 $68 $39 $52 $25 $39 $41 $47 $52 $55 $44 $71 $61 $59 $68 $31 $135 $143 $85 Degree Bachelor's Bachelor's Bachelor's High School Master's Bachelor's Bachelor's Bachelor's Bachelor's High School Bachelor's Bachelor's Bachelor's High School Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Master's Bachelor's Bachelor's Master's Master's Bachelor's Home State Virginia Virginia New York Maryland New York Virginia Delaware New York Delaware Delaware Maryland New York Maryland Maryland New York Delaware New York Maryland New York Maryland Maryland New York Virginia Virginia Virginia New York Work Schedule Full Time Full Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Rank Analyst Analyst Analyst Analyst CEO Developer Developer Developer Developer Developer Developer Developer Developer Developer Developer Developer IT Specialist IT Specialist Manager Manager Manager Representative Representative Senior Staff Senior Staff Senior Staff Name Echo Mike Oscar Romeo Alpha Delta Foxtrot Kilo Lima November Quebec Tango Uniform Victor Whiskey X-ray Juliet Sierra Hotel Papa Yankee India Zulu Bravo Charlie Golf Title Ms. Ms. Mr. Ms. Mr. Mr. Ms. Mr. Ms. Mr. Ms. Ms. Mr. Mr. Ms. Mr. Ms. Ms. Ms. Ms. Mr. Ms. Ms. Ms. Mr. Ms. Employee ID 29584 12037 62958 73891 96572 96689 27981 19547 49776 47389 34441 49040 51585 44791 76744 31811 82912 31684 24581 10641 26138 47611 53729 96491 76850 13302 Job Series Finance/Accounting Finance/Accounting Finance/Accounting Finance/Accounting CEO Software Development Software Development Software Development Software Development Software Development Software Development Software Development Software Development Software Development Software Development Software Development IT IT Sales Finance/Accounting Software Development Sales Sales CIO CFO Analytics Salary in $1000 $62 $47 $48 $49 $155 $56 $45 $24 $68 $39 $52 $25 $39 $41 $47 $52 $55 $44 $71 $61 $59 $68 $31 $135 $143 $85 Degree Bachelor's Bachelor's Bachelor's High School Master's Bachelor's Bachelor's Bachelor's Bachelor's High School Bachelor's Bachelor's Bachelor's High School Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Bachelor's Master's Bachelor's Bachelor's Master's Master's Bachelor's Home State Virginia Virginia New York Maryland New York Virginia Delaware New York Delaware Delaware Maryland New York Maryland Maryland New York Delaware New York Maryland New York Maryland Maryland New York Virginia Virginia Virginia New York Work Schedule Full Time Full Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Rank Analyst Analyst Analyst Analyst CEO Developer Developer Developer Developer Developer Developer Developer Developer Developer Developer Developer IT Specialist IT Specialist Manager Manager Manager Representative Representative Senior Staff Senior Staff Senior Staff
Purchase answer to see full attachment
Explanation & Answer:
Worksheet
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Name
Juliet
Quebec
Golf
Papa
Sierra
Charlie
Kilo
Zulu
Victor
Romeo
Oscar
Echo
Whiskey
Foxtrot
Mike
Alpha
Hotel
X-ray
India
Lima
Uniform
November
Yankee
Tango
Bravo
Delta

Title
Ms.
Ms.
Ms.
Ms.
Ms.
Mr.
Mr.
Ms.
Mr.
Ms.
Mr.
Ms.
Ms.
Ms.
Ms.
Mr.
Ms.
Mr.
Ms.
Ms.
Mr.
Mr.
Mr.
Ms.
Ms.
Mr.

Employee ID

82912
34441
13302
10641
31684
76850
19547
53729
44791
73891
62958
29584
76744
27981
12037
96572
24581
31811
47611
49776
51585
47389
26138
49040
96491
96689

Job Series
IT
Software Development
Analytics
Finance/Accounting
IT
CFO
Software Development
Sales
Software Development
Finance/Accounting
Finance/Accounting
Finance/Accounting
Software Development
Software Development
Finance/Accounting
CEO
Sales
Software Development
Sales
Software Development
Software Development
Software Development
Software Development
Software Development
CIO
Software Development

Salary in $1000
$55
$52
$85
$61
$44
$143
$24
$31
$41
$49
$48
$62
$47
$45
$47
$155
$71
$52
$68
$68
$39
$39
$59
$25
$135
$56

Degree
Bachelor's
Bachelor's
Bachelor's
Bachelor's
Bachelor's
Master's
Bachelor's
Bachelor's
High School
High School
Bachelor's
Bachelor's
Bachelor's
Bachelor's
Bachelor's
Master's
Bachelor's
Bachelor's
Bachelor's
Bachelor's
Bachelor's
High School
Master's
Bachelor's
Master's
Bachelor's

Home State
New York
Maryland
New York
Maryland
Maryland
Virginia
New York
Virginia
Maryland
Maryland
New York
Virginia
New York
Delaware
Virginia
New York
New York
Delaware
New York
Delaware
M...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags