Regularized beta function is the CDF of beta distribution. In ms_xls (msoffice 2010) there is a standard method BETA.DIST(x, a, b, TRUE) to calculate the CDF of beta distribution. Now the problem is, this (BETA.DIST()) giving me correct values till the point x >= (a+1) / (a+b+2) but if x < (a+1) / (a+b+2) its not giving me the correct values.

For the underlying calculation of incomplete beta (please refer to http://astronu.jinr.ru/wiki/upload/d...RecipesinC.pdf ) of section 6.4. Here it saying

if x<(a+1) / (a+b+2) use continued fraction directly but if x>=(a+1) / (a+b+2) use continued fraction after using symmetric transformation.

DETA.DIST() of xls always calculate CDF (cumulative distribution function) assuming that x >= (a+1) / (a+b+2) (because when x >= (a+1) / (a+b+2) I am getting exactly same value from my system and xls). Now the question / doubt is why there is a correction when x<(a+1) / (a+b+2) (this is not in xls BETA.DIST()). Or is it that incomplete beta is no more a CDF of beta distribution when x < (a+1) / (a+b+2).

Thanks in advance for your reply.

Regards

Deepak

////// This method is copied from "NumericalRecipesinC"//////////// section 6.4

Returns the incomplete beta function Ix(a, b).

{

float betacf(float a, float b, float x);

float gammln(float xx);

void nrerror(char error_text[]);

float bt;

if (x < 0.0 || x > 1.0) nrerror("Bad x in routine betai");

if (x == 0.0 || x == 1.0)

bt=0.0;

else Factors in front of the continued fraction.

bt=exp(gammln(a+b)-gammln(a)-gammln(b)+a*log(x)+b*log(1.0-x));

if (x < (a+1.0)/(a+b+2.0)) Use continued fraction directly.

return bt*betacf(a,b,x)/a;

else Use continued fraction after making the symmetry transformation.

return 1.0-bt*betacf(b,a,1.0-x)/b;

}