View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darren Hill[_3_] Darren Hill[_3_] is offline
external usenet poster
 
Posts: 68
Default Probability of dice throws

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