Suppose, for the sake of argument, that you are the Director of HR for a large company and that you want to conduct a personal interview with 20 of the 75 new-hires in the company who recently completed a one-day orientation program about the various benefits programs available to employees at your company to see how the orientation program can be improved. You want to take a random sample of 20 of these 75 new-hires.

(a) Set up a spreadsheet of frame numbers for these new-hires with the heading: FRAME NUMBERS.

(b) Then, create a separate column to the right of these frame numbers which duplicates these frame numbers with the title: Duplicate frame numbers.

(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 20 new-hires that you would select for your personal interview study.

(g) Save the file as: RAND5