scott wrote:
>> 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.

See my other post; Excel has a function to directly compute a binomial 
distribution, apparently. (And cumulatively, if you wish.)

Post a reply to this message