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
Purchase answer to see full attachment
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...