View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
watermt watermt is offline
external usenet poster
 
Posts: 82
Default Excel 2003 Data Analysis - Sampling

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