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

's Computer Specifications

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?

's Computer Specifications

=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?

's Computer Specifications

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?

's Computer Specifications

=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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assign random numbers	=?Utf-8?B?SmltaW5pYw==?=	Microsoft Access	2	30th Oct 2007 10:54 PM
Non-random numbers generated by excel's data analysis random gener	=?Utf-8?B?QWxsaWU=?=	Microsoft Excel Worksheet Functions	10	17th Sep 2005 06:19 AM
Re: Non-random numbers generated by excel's data analysis random gener	Harlan Grove	Microsoft Excel Misc	2	13th Sep 2005 04:06 PM
How do I generate non-recurring random numbers to assign groups?	=?Utf-8?B?aGtvZWhuaw==?=	Microsoft Excel Misc	1	12th Sep 2005 08:07 PM
How do I assign random numbers to a table in Access 2002?	=?Utf-8?B?bHNjaG9yZG9jaw==?=	Microsoft Access	4	25th Feb 2005 10:23 PM