View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default 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.