Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Random Numbers | Excel Worksheet Functions | |||
Getting rid of random white lines in Excel | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Random Numbers | Excel Worksheet Functions |