Excel 2003 Data Analysis - Sampling
Assuming your list of numbers is in column A, put this in column B:
=RAND()
Sort both columns by column B and then use the first 10 numbers. Sort again to
get a new "sample".
watermt wrote:
What would you recommend if I want to avoid returning the same data point?
"Glenn" wrote:
watermt wrote:
When performing a Sampling of numbers it's returning a duplication of one of
the numbers. I checked my list of numbers and the suspect number does not
appear more than once in my "sampled" column of numbers.
Is this a "bug" in the Sampling feature or could I be doing something wrong?
Mike
In a random sampling, the results are random, including the possibility of
returning the same data point more than once.
|