BETA_DIST

BETA_DIST(arg1, arg2, arg3, arg4, arg5, arg6) → { number }

Returns the beta probability distribution function.

Parameters:

Name Type Description
arg1 number

The value between A and B at which to evaluate the function.

arg2 number

The alpha parameter of the distribution which must be greater than 0.

arg3 number

The beta parameter of the distribution which must be greater than 0.

arg4 boolean

Specifies if this is the cumulative distribution function (true) or the probability density function (false).

arg5 number

An optional lower bound to the interval of x (A). If omitted, it is equal to 0.

arg6 number

An optional upper bound to the interval of x (B). If omitted, it is equal to 1.

Returns:

Type
number

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var avg = oFunction.BETA_DIST(0.4, 4, 5, false);
oWorksheet.GetRange("B2").SetValue(avg);
builder.SaveFile("xlsx", "BETA_DIST.xlsx");
builder.CloseFile();

Resulting document