
Re: Help with probability&stat problem
Posted:
Jun 13, 2007 8:29 PM


> Everybody curious to learn the logic of this > procedure should consult > > _____Wikipedia: Continuity correction > > ____Licas
What Wikipedia failed to mention is that one could get the exact result from Excel in about 20 seconds, using BINOMDIST and inputting the three arguments plus "TRUE" to obtain the cumulative binomial. For example, in the case of p = 0.20, N = 110 and x = 10, the normal approximation overestimates the true probability and then adding the continuity correction term further exaggerates the error. It is also so complicated to apply that a typical user such as Afonso could not calculate the numbers correctly.
Jack

