- #71
mfb
Mentor
- 37,263
- 14,098
There it is (bold added by me).Jonathan212 said:Can't I just ignore that information and instead give the fact that the binomial distribution in
= 1 - BINOMDIST( M - 1 , N , 0.5, 1 )
is approximated by the normal distribution in
= 1 - NORMDIST( M - 1, N * 0.5, SQRT( N * 0.5 * (1-0.5) ), 1 )
where we'd replace 0.5 by 1/24,435,180 and use N = 10,457,692,468 and M = 465 ?
Why? Wouldn't a deviation in the other direction be equally suspicious?Jonathan212 said:EDIT: just found the error. You're looking at the "|z| >" value but you should be looking at "z >".
Within the approximation from the Poisson distribution or normal distribution this doesn't matter. 464.5 should be slightly better.Jonathan212 said:And because we want 465 or more, ie > 464, you should have calculated how many standard deviations 464 is from 428, not 465 from 428.
WolframAlpha can calculate some extreme values. Check individual parts - you'll see the approximation is a *really* good one here.