LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 1998)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 11 Aug 1998 14:40:42 -0400
Reply-To:   David Howell <dhowell@ZOO.UVM.EDU>
Sender:   "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From:   David Howell <dhowell@ZOO.UVM.EDU>
Subject:   Re: Question on random number generation
In-Reply-To:   <000801bdc554$eb2d9640$>
Content-Type:   text/plain; charset="us-ascii"


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. >-------------------------------------------------------------- > > > David C. Howell Phone: (802) 656-2670 Dept of Psychology Fax: (802) 656-8783 University of Vermont email: Burlington, VT 05405

Back to: Top of message | Previous page | Main SPSSX-L page