Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simulations
How do you simulate an unfair spinner or die?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simulations
Hello,
Another alternative would be my UDF redw: http://www.sulprobil.com/html/distributions.html Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where can I download an Excel add-on to do MonteCarlo simulations | Excel Worksheet Functions |