Methods Manual: Table of Random Numbers

  1. List the cases to be randomized in a column on a spreadsheet.

  2. Assign the number from the table to each case. Start anywhere on the table, and move in any direction (up, down, across, diagonally).

  3. To select a sample, select the desired number for the sample from either the highest or lowest assigned random numbers. For example, for N=10, choose the names with the 10 lowest random numbers.
 

Table of Random Numbers
  33 72 3 74 99 28
  5 53 29 64 60 49
  33 8 45 18 48 47
  91 70 17 79 10 93
  28 8 18 7 56 89
  66 97 62 2 60 91
  52 29 14 31 26 95
  37 17 66 25 11 76
  4 67 67 22 21 22
  96 31 35 1 41 0
  36 51 35 78 44 72
  30 76 73 22 84 51
  1 95 65 32 42 35
  76 97 6 87 84 54
  57 4 51 50 86 81
  30 15 65 73 7 34
  43 88 23 92 18 83
  15 2 68 6 49 62
  92 92 12 67 30 15
  98 76 36 9 5 93

Generate random numbers using Excel