|
Dale,
Suppose you want 100 random numbers between 1 and 276, without replacement.
Simply create a data set with 276 rows, where column1 = $casenum. Then
compute column2 as any old random variable. Now sort on column 2, and
column 1 will contain the numbers 1 -- 276 in random order. If you only
want 100 of them, just take the first 100 rows. $casenum is an SPSS
variable that simply numbers your cases in order, but I would assume that
Excel has something equivalent. Or you can fill in by dragging if you don't
want too many numbers.
Dave Howell
At 02:21 PM 8/11/98 -0400, you 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
>
David C. Howell Phone: (802) 656-2670
Dept of Psychology Fax: (802) 656-8783
University of Vermont email: David.Howell@uvm.edu
Burlington, VT 05405
http://www.uvm.edu/~dhowell/StatPages/StatHomePage.html
http://www.uvm.edu/~dhowell/Psych95/LiesHomePage.html
|
