|
![](/i/fill.gif) |
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
|
![](/i/fill.gif) |