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

Check out this 8 min video on Sampling..
http://www.youtube.com/watch?v=SoK9kq-0uXg

If this post helps click Yes
---------------
Jacob Skaria


"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

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.

Way too complicated for my staff. We have a huge list of numbers (e.g.
12345, 67890, 45678) all a series of five digits. I put them in a column and
used the Sampling feature to retrieve 10 random numbers. It duplicated one
of the numbers in the list of 10, 42567 and 42567.

I guess I'm trying to find out why it would do this?

"Jacob Skaria" wrote:

Check out this 8 min video on Sampling..
http://www.youtube.com/watch?v=SoK9kq-0uXg

If this post helps click Yes
---------------
Jacob Skaria


"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

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.

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.

I believe this is know as sampling with replacement. The Data Analysis tool
does not allow you to control this option.

I think you may need to write VBA code to do this, although you can do a
fair job with formulas by using the =RAND() function.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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.