I have generated a set of numbers using the uniform function of the random number generator with a seed of 1325 and I am trying to figure out how to select a simple random sample of 7 of the 21 files I have, any help would be appreciated
I have generated a set of numbers using the uniform function of the random number generator with a seed of 1325 and I am trying to figure out how to select a simple random sample of 7 of the 21 files I have, any help would be appreciated
List the files in column A from A1 thru A21.
In B1 thru B21 enter =RAND()
In C1 thru C7 enter:
=INDEX($A$1:$A$21,MATCH(LARGE($B$1:$B$21,ROW()),$B$1:$B$21,0))
Gary's Student
thanks a ton!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks