Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)

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