> Wikipedia informs me that what you're looking for is a "binomial 
> distribution".

Thanks - that was the key I needed!

> According to this, we have the probability of getting exactly K heads as
>
>   (N choose K) * P(H)^K * (1 - P(H))^(N-K)

That *is* useful, at least using this formula I get correct results, 
although it's still a bit clumsy.

I will continue with Excel now trying to make it a bit neater.

Post a reply to this message