|
a simple way to do this is to generate a random variable column alongside
the variable you woant to randomise & then sort according to the rv.
this gives random permutation of original values
cheers
diana kornbrot
xOn Tue, 11 Aug 1998, Dale
Pietrzak wrote:
> Gerard;
>
> Your response triggered a questin I am going to have to deal with
> this fall. In my case I will need to obtain random numbers
> without the replacement. I have Excel, SPSS, SYSTAT and several
> other programs but you can you think of an Excel command set that
> does this? I would be indebted.
>
> Dale
> ---------------------------------------------------------------
> Dale Pietrzak, Ed.D.
> Kent State University
> Counseling & Human Development Programs
> PO Box 5190
> Kent, OH 44242
> (330) 672-2662: Phone
> (330) 672-3063: Fax
> ---------------------------------------------------------------
> No ... stories are not reality. They are magic. They
> magically transform how we cope with reality.
> --------------------------------------------------------------
> http://www.ezo.net/cgi-win/dispage.exe/pietrzak
> http://www.geocities.com/HotSprings/Spa/3064
>
|
