D
Darren Hill
I want to use Excel to calculate an odd set of probabilities.
Let's say I'm rolling a number of six-sided dice: anywhere from 3 to 12.
Given that I know the highest die is, say, 4, how do I calculate the
probability of the lowest die being 1, 2, 3, or even 4?
Can anyone supply the process I need to achieve this?
I've posted this in programming because I plan to write a macro to output
the probalities of each of the 36 combinations of high and low dice (1,1
to 6,6).
Darren
Let's say I'm rolling a number of six-sided dice: anywhere from 3 to 12.
Given that I know the highest die is, say, 4, how do I calculate the
probability of the lowest die being 1, 2, 3, or even 4?
Can anyone supply the process I need to achieve this?
I've posted this in programming because I plan to write a macro to output
the probalities of each of the 36 combinations of high and low dice (1,1
to 6,6).
Darren