Hi all,

I want to draw a random sample [with replacement] of size 10 (suppose) from a population having members : 1, 2, 3, and 4, where I assume following:

Probability that 1 will be drawn is : 0.1
Probability that 2 will be drawn is : 0.4
Probability that 3 will be drawn is : 0.4
Probability that 4 will be drawn is : 0.1

Can anyone tell me that : is there any VBA function for doing that? If no, how I can write my own function using VBA?

Thanks and Regards,