can you assign random numbers to many different lines of row?
 

I am trying to assign random numbers to my population; one random number to
one sample. The population is recorded in rows in excel. Is there a function?

can you assign random numbers to many different lines of row?
 

=RAND()......and copy down

Vaya con Dios,
Chuck, CABGx3



"random number generator" wrote:

I am trying to assign random numbers to my population; one random number to
one sample. The population is recorded in rows in excel. Is there a function?

can you assign random numbers to many different lines of row?
 

if I do that, some samples may have same random numbers assigned. How do I
make sure that each sample has a different random number assigned to it?

"CLR" wrote:

=RAND()......and copy down

Vaya con Dios,
Chuck, CABGx3



"random number generator" wrote:

I am trying to assign random numbers to my population; one random number to
one sample. The population is recorded in rows in excel. Is there a function?

can you assign random numbers to many different lines of row?
 

=RAND() generates a sequence of numbers that will not repeat for a very long
time. How long depends on your verson, but it is unlikely to impact what you
are doing unless you are rounding the random numbers, in which case you have
not provided enough information.

Jerry

"random number generator" wrote:

if I do that, some samples may have same random numbers assigned. How do I
make sure that each sample has a different random number assigned to it?

"CLR" wrote:

=RAND()......and copy down

Vaya con Dios,
Chuck, CABGx3



"random number generator" wrote:

I am trying to assign random numbers to my population; one random number to
one sample. The population is recorded in rows in excel. Is there a function?