ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   anaysis tookpak (https://www.excelbanter.com/excel-discussion-misc-queries/76008-anaysis-tookpak.html)

cathyh

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,

Niek Otten

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,




cathyh

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,





Niek Otten

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,







Niek Otten

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