simulations

[Notey]

How do you simulate an unfair spinner or die?

 

[Sandy Mann]

You don't say how you want to have the die being unfair. This will give a 6
for 50% of the time, 3 for 25% of the time and the other numbers for 8 1/3%
of the time:

=CHOOSE(INT(RAND()*12+1),1,2,3,3,3,4,5,6,6,6,6,6)
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Notey]

Thank you!

-Notey

You don't say how you want to have the die being unfair. This will give a 6
for 50% of the time, 3 for 25% of the time and the other numbers for 8 1/3%
of the time:

=CHOOSE(INT(RAND()*12+1),1,2,3,3,3,4,5,6,6,6,6,6)
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You're Very welcome. Thanks for the feedback.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bernd P]

Hello,

Another alternative would be my UDF redw:
http://www.sulprobil.com/html/distributions.html

Regards,
Bernd