simulations
 

How do you simulate an unfair spinner or die?

simulations
 

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


Replace @mailinator.com with @tiscali.co.uk


"Notey" wrote in message
...
How do you simulate an unfair spinner or die?

simulations
 

Thank you!

-Notey

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Notey" wrote in message
...
How do you simulate an unfair spinner or die?

simulations
 

You're Very welcome. Thanks for the feedback.

--
Regards,

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


Replace @mailinator.com with @tiscali.co.uk


"Notey" wrote in message
...
Thank you!

-Notey

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Notey" wrote in message
...
How do you simulate an unfair spinner or die?

simulations
 

Hello,

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

Regards,
Bernd