Suppose that your Sales department at your company wants to do a "customer satisfaction survey" of 20 of your company's 76 "key accounts." Suppose, further, that your Sales Vice-President has defined a key account as a customer who purchased at least $30,000 worth of merchandise from your company in the past 90 days.
(a) Set up a spreadsheet of frame numbers for these customers 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 ID number of the first 20 customers that your Sales Vice-President would call for his phone survey.
(g) Save the file as: RAND5