Frequently asked questions

How can I randomize 50 subjects into 2 treatment groups with exactly 25 subjects each?

 

Proceed as follows:

Use the Fill column command (Tools menu) to do the following:

Fill column A, rows 1 to 25 with value 1, and rows 26 to 50 with value 2.

Fill column B, rows 1 to 50 with a random number, using the formula RAND(1) (be sure to select the option "Convert formulas to values").

Next, sort the data according to column B (Tools menu - Sort rows).

You now have a random number 1 or 2 (25 of each) in column A.

 

Return to FAQ

This site uses cookies to store information on your computer. More info...