N
Novice
Dear All,
I need to randomly select 1 out of n subjects (n=2,...5 etc). I know
the typical approach is to assign random numbers to all n subjects,
and pick the one corresponding to the first random number in the
string of numbers (i.e. I get 3, 4, 1, 2 as a string of random
numbers, this means that I need to select subject/cell number 3).
Can somebody please advise if the following is acceptable: assign
random numbers and then select the one that corresponds to the maximum
(or minimum). I'm doing this in excel, so the random numbers generated
have values between 0 and 1 (rand() function).
The reason I want to use this approach is that I need to randomly
select for a postal survey purposes one household member from each
household. There may be up to 5 members in each household, and there
are total of 1000 households. If selection of max(min) random number
appoach is used it is easy to make escel to work out all necessary
selections. Otherwise i don't see any other choice but do it manually!
Thanks,
Novice
I need to randomly select 1 out of n subjects (n=2,...5 etc). I know
the typical approach is to assign random numbers to all n subjects,
and pick the one corresponding to the first random number in the
string of numbers (i.e. I get 3, 4, 1, 2 as a string of random
numbers, this means that I need to select subject/cell number 3).
Can somebody please advise if the following is acceptable: assign
random numbers and then select the one that corresponds to the maximum
(or minimum). I'm doing this in excel, so the random numbers generated
have values between 0 and 1 (rand() function).
The reason I want to use this approach is that I need to randomly
select for a postal survey purposes one household member from each
household. There may be up to 5 members in each household, and there
are total of 1000 households. If selection of max(min) random number
appoach is used it is easy to make escel to work out all necessary
selections. Otherwise i don't see any other choice but do it manually!
Thanks,
Novice