![]() |
anaysis tookpak
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, |
anaysis tookpak
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, |
anaysis tookpak
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, |
anaysis tookpak
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, |
anaysis tookpak
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, |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com