Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I generate non-recurring random numbers to assign groups?
I am attempting to use random number generator to assign numbers to subjects
in a group so to give each subject a group assignment. Each subject blocked by weight, then assigned a number. |
#2
|
|||
|
|||
This is only an example, but the concept may help you.
Let's say we want do sample ten numbers randomly (and uniquely) from a distribution of one to one hundred. Enter the numbers one to one hundred in a column. In the next column enter +RAND() and copy down. Sort by the second column; this will jumble the first column. Just take the first ten entries in the first column. They will be randomly picked from the distribution with no repeats. Hope this helps -- Gary''s Student "hkoehnk" wrote: I am attempting to use random number generator to assign numbers to subjects in a group so to give each subject a group assignment. Each subject blocked by weight, then assigned a number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate random numbers 1-100 without any repeats? | Excel Worksheet Functions | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Excel Discussion (Misc queries) | |||
Generate random numbers between two values and with a given mean | Excel Worksheet Functions | |||
generate random numbers | Excel Worksheet Functions |