Suppose that you are the HR director at a large company and that you want to conduct
Question:
Suppose that you are the HR director at a large company and that you want to conduct a phone interview with 10 of the 114 employees who have elected to be included in the company’s Vision Care Plan which was instituted a year ago to obtain their feedback about how well the plan has been working for them.
(a) Set up a spreadsheet of frame numbers for these claims with the heading:
FRAME NO.
(b) Then, create a separate column to the right of these frame numbers which duplicates these frame numbers with the title: Duplicate frame no.
(c) Then, create a separate column to the right of these duplicate frame numbers entitled “Random number” and use the ¼RAND() function to assign random numbers to all of the frame numbers in the duplicate frame numbers column. Then, change this column format so that three decimal places appear for each random number
(d) Sort the duplicate frame numbers and random numbers into a random order
(e) Print the result so that the spreadsheet fits onto one page
(f) Circle on your printout the I.D. number of the first 10 employees that would be used in this research study.
(g) Save the file as: RANDOM6
Step by Step Answer:
Excel 2013 For Human Resource Management Statistics A Guide To Solving Practical Problems
ISBN: 97173
2nd Edition
Authors: Thomas J. Quirk, Julie Palmer Schuyler