In  Example 3.7 (p. 235) of the textbook, you learned how to use Table B to select
30 two-digit labels.  In this Exercise, you will learn to use Random Number Generation (RNG) instead of Table B.
 
 
 

In Example 3.7, you need to get the two-digit labels from 01 to 30 in a  random order.
Here is an easy way to do it:
 

Fill the column A1:A30 with the numbers 1 to 30.  These are the labels for the 30 rats.

Then open the "Random Number Generation " window from the Data Analysis tool box.
Select 1 Variable, 30 Random Numbers and the "Uniform" distribution between 0 and 1 ; then choose
the  Output Range to start in cell B1 .

You will get 30 random numbers between 0 and 1 in the cells B1:B30.

Next, "SORT" the columns A1:B30 by column B.  You will get the 30 "two-digit labels" from column A in a random
order.  Now  you may proceed with  Example 3.7 using these labels: the rats corresponding to yours first 15 labels
are assigned to the "experimental" group; the remaining 15 rats are the control group.  (Of course, your random
assignment is different than the one on page 236 of the textbook.)

The RNG window allows the user to choose a "Random Seed" so that you can decide whether or not to
reproduce  the exact same list of random numbers: If you input a new seed, then RNG will produce a completely
new list of random numbers; if you input the same seed again, then RNG will reproduce the same exact list of
random numbers.   Setting a Random Seed is similar to using Table B by starting at a specified row.

Generate 3 new lists of  random numbers, each of length 30, in columns C, D, and E.
 For columns C and D use seed 23, and for column E use seed 531.  (If you hate the number 23, use your birthday instead.)
                 Observe that the lists in columns C and D are identical, but column E is different.  Goood!
 
 

This procedure to get numerical "labels" in a random order could be used instead of Table B
for any exercise which requires randomization.
 

PLEASE use the "Random Seed" 1016 for both textbook exercises 3.14 and 3.32.
Then all students will generate the same sequence of numbers, and the grading
becomes simpler.  Thanks!

Question for textbook Ex. 3.14.   Hand in an Excel worksheet showing the "2-digit" labels in column A, the
corresponding uniform random numbers in column B, and the corresponding subject names in column C.
Also, clearly indicate on the list which subjects are assigned to the experimental group, and which are
assigned to the control group.
 

For textbook  Ex. 3.32:

Part (a):  Within each block, leave the subjects in order of increasing Excess Weight (EW).

Part (b):  To randomly assign treatments, use a single sequence consisting of twenty Uniform Random Numbers (URN) based on the seed 1016.  Be sure you understand what bias would be introduced if,
instead, we had used the same sequence of four uniform random numbers (with seed 1016) within
each block.

Hand in an Excel worksheet with your results in columns A:E under the following respective
headings: Block #, Name, EW, URN, Treatment.