Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
why would the "Sampling" tool render duplicate values?
if i have 60 focus group candidates, and i do a random sampling of the 60 candidates' numbers to get a sample of 10 random candidates, why would there be duplicates? thanks, |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Why not?
But look he http://www.tushar-mehta.com/excel/ne...ion/index.html -- Kind regards, Niek Otten "cathyh" wrote in message ... why would the "Sampling" tool render duplicate values? if i have 60 focus group candidates, and i do a random sampling of the 60 candidates' numbers to get a sample of 10 random candidates, why would there be duplicates? thanks, |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
thanks for the feedback -- however, if i do a random sampling, ie a focus
group, one candidate cannot be in the focus group two time - right? "Niek Otten" wrote: Why not? But look he http://www.tushar-mehta.com/excel/ne...ion/index.html -- Kind regards, Niek Otten "cathyh" wrote in message ... why would the "Sampling" tool render duplicate values? if i have 60 focus group candidates, and i do a random sampling of the 60 candidates' numbers to get a sample of 10 random candidates, why would there be duplicates? thanks, |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
That is just one application of "random" (I'm not even sure it is).
If I have 10 positions that I want to fill randomly with numbers 1-10, and I've done 9 and duplicates are excluded, there is not a lot of randomness about the last one. I think all depends on how "random" is applied. I hope the link to Tushar gave you what is required in your situation. -- Kind regards, Niek Otten "cathyh" wrote in message ... thanks for the feedback -- however, if i do a random sampling, ie a focus group, one candidate cannot be in the focus group two time - right? "Niek Otten" wrote: Why not? But look he http://www.tushar-mehta.com/excel/ne...ion/index.html -- Kind regards, Niek Otten "cathyh" wrote in message ... why would the "Sampling" tool render duplicate values? if i have 60 focus group candidates, and i do a random sampling of the 60 candidates' numbers to get a sample of 10 random candidates, why would there be duplicates? thanks, |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Just to add: rolling dice is supposed to be random. That doesn't exclude
numbers that already have come up, though. -- Kind regards, Niek Otten "Niek Otten" wrote in message ... That is just one application of "random" (I'm not even sure it is). If I have 10 positions that I want to fill randomly with numbers 1-10, and I've done 9 and duplicates are excluded, there is not a lot of randomness about the last one. I think all depends on how "random" is applied. I hope the link to Tushar gave you what is required in your situation. -- Kind regards, Niek Otten "cathyh" wrote in message ... thanks for the feedback -- however, if i do a random sampling, ie a focus group, one candidate cannot be in the focus group two time - right? "Niek Otten" wrote: Why not? But look he http://www.tushar-mehta.com/excel/ne...ion/index.html -- Kind regards, Niek Otten "cathyh" wrote in message ... why would the "Sampling" tool render duplicate values? if i have 60 focus group candidates, and i do a random sampling of the 60 candidates' numbers to get a sample of 10 random candidates, why would there be duplicates? thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
anaysis tool pack | Excel Discussion (Misc queries) |