#1   Report Post  
Posted to microsoft.public.excel.misc
cathyh
 
Posts: n/a
Default 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,
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default 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,



  #3   Report Post  
Posted to microsoft.public.excel.misc
cathyh
 
Posts: n/a
Default 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,




  #4   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default 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,






  #5   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default 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,







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
anaysis tool pack Dan Perry Excel Discussion (Misc queries) 4 May 11th 05 04:17 PM


All times are GMT +1. The time now is 08:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"