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

CRITBINOM(n, p, alpha)

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
-----Original Message-----
Is there a easy workaround to the problems with critbinom
given an error when n 1030 in the equation:

CRITBINOM(n, p, alpha)
.

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
--
Dana DeLouis
Win XP & Office 2003


"Kevin" wrote in message
...
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
-----Original Message-----
Is there a easy workaround to the problems with critbinom
given an error when n 1030 in the equation:

CRITBINOM(n, p, alpha)
.

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.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Robert Schwartz wrote in message ...
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.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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