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

If you are just looking for the probablity of the sum of an ygiven throw it
looks like this
Sum Probability
2 1
3 2
4 3
5 4
6 5
7 6
8 5
9 4
10 3
11 2
12 1

HTH

"Darren Hill" wrote:

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