Suppose that you are the Director of a Master’s degree program in Human Resources at a university and that you want to interview a random sample of students who are scheduled to graduate from the program this next June so that you can obtain their suggestions about how the program can be improved.

Suppose that you have 63 Master’s students who are scheduled to graduate. You want to randomly select 15 of these 63 students for a personal interview.

(a) Set up a spreadsheet of frame numbers for these students with the heading:
FRAME NUMBERS using the Home/Fill commands.

(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 NO. and use the ¼RAND() function to assign random numbers to all of the frame numbers in the duplicate frame numbers column, and 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 15 students that you would use in your interviews.
(g) Save the file as: RAND9 Important note: Note that everyone who does this problem will generate a different random order of student ID numbers since Excel assigns a different random number each time the ¼RAND() command is used. For this reason, the answer to this problem given in this Excel Guide will have a completely different sequence of random numbers from the random sequence that you generate. This is normal and what is to be expected.