Critbinom

[Robert]

Is there a easy workaround to the problems with critbinom
given an error when n > 1030 in the equation:

CRITBINOM(n, p, alpha)

 

[Kevin]

Is this a user defined function? Is a value for n > 1030
valid? If not, test this value before you call the
function. If it is greater than 1030, take appropriate
action. If a value greater than 1030 is valid (and this is
a function you defined) the code for the function would be
necessary to debug.

Hope that helps!

Kevin

 

[Dana DeLouis]

Don't know if this will help, but in Excel 2003, the statistical function
...

=CRITBINOM(1031,0.5,0.75)
=CRITBINOM(2000,0.5,0.75)

returned.
526
1015

I believe that "CRITBINOM" was one of the functions that was "improved" in
Excel 2003.
What version, and data, are you using?

HTH

 

[Robert Schwartz]

This is an excel function. CRITBINOM. Having a value of > 1030 is a
known problem in excel 2000 from Microsoft. See article #828117 from
Microsoft. They fixed it in excel 2003 but I need a work around for
excel 2000, since I can not upgrade to excel 2003.

 

[Ian Smith]

This is an excel function. CRITBINOM. Having a value of > 1030 is a
known problem in excel 2000 from Microsoft. See article #828117 from
Microsoft. They fixed it in excel 2003 but I need a work around for
excel 2000, since I can not upgrade to excel 2003.

You are welcome to use the
functions in http://members.aol.com/iandjmsmith/Examples.xls

In this case the crit_binomial function is the one you want.

Ian Smith