Data Analysis Sampling Tool

T

tjtjjtjt

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
 
D

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>
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

tjtjjtjt said:
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
Click to expand...
duplicate value. Is there anyway to head this off, while still taking a random sample? Thanks.
 
T

tjtjjtjt

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
 
Top