java 实现 excel normsdist_Excel实现的NORM NORMDIST函数中的幻数

寻找Excel的NORMDIST的C实现(累计)

功能我发现this on a website：

static double normdist(double x, double mean, double standard_dev)

{

double res;

double x=(x - mean) / standard_dev;

if (x == 0)

{

res=0.5;

}

else

{

double oor2pi = 1/(sqrt(double(2) * 3.14159265358979323846));

double t = 1 / (double(1) + 0.2316419 * fabs(x));

t *= oor2pi * exp(-0.5 * x * x)

* (0.31938153 + t

* (-0.356563782 + t

* (1.781477937 + t

* (-1.821255978 + t * 1.330274429))));

if (x >= 0)

{

res = double(1) - t;

}

else

{

res = t;

}

}

return res;

}

我有限的数学知识让我想到了Taylor series,但我无法确定这些数字的来源：

0.2316419,

<