Data Analysis Sampling Tool

[Guest]

I just used the Sampling Tool for Excel 2003. I set it to return a random sample of 10, from a population of 60. It returned a duplicate value. Is there anyway to head this off, while still taking a random sample? Thanks
tj

 

[David McRitchie]

References to a couple of postings in
http://www.mvps.org/dmcritchie/excel/random.htm

Sounds like there should be a Random Order Sort <grin>

I just used the Sampling Tool for Excel 2003. I set it to return a random sample of 10, from a population of 60. It returned a

duplicate value. Is there anyway to head this off, while still taking a random sample? Thanks.

 

[Guest]

Thanks for the links
A "random" filter might be a good idea. I could create a help column and use =rand() to assign a random value to each of the subjects. Then, something like the Top Ten AutoFilter would do the trick
Using the Sampling Tool...well, it's hard to ask the same person to participate in the same focus group twice.
Thanks again

tj