Probability of dice throws

[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

[Jim Thomlinson]

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
>