View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default How to sample data without returning duplicates?

Not to split hairs, as i think i answered the question that it could not be
done with this formula....the definition of random is:
Statistics. of or characterizing a process of selection in which each item
of a set has an equal probability of being chosen.

So by definition, no powerball is NOT random, the machine randomly selects a
number, but each number does not have the same chance of being chosen,
chosing 5 out of 10 numbers excluding duplicates, the first person picked was
picked with 1:10 odds and the 5th 1:5.

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"joeu2004" wrote:

On Aug 7, 11:14 am, John Bundy (remove) wrote:
You are probably using the random sample portion, a random sample
can not be take from data while ignoring what has been taken, it wouldn't
be random.


So by your definition, a Powerball-like lottery does not do random
selection?(!)

Of course that's wrong. You can do random sampling with and without
replacement.

Arguably, without replacement is the most common form of random
sampling. Can you imagine a political survey where the opinions of
one person might be counted more than once? Can you imagine a jury
pool where one person might go through voir dire twice for the same
jury panel?