BETA_INV

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

Returns the inverse of the cumulative beta probability density function (BETA_DIST).

Parameters:

Name Type Description
arg1 number

A probability associated with the beta distribution.

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 number

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

arg5 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_INV(0.2, 4, 5);
oWorksheet.GetRange("B2").SetValue(avg);
builder.SaveFile("xlsx", "BETA_INV.xlsx");
builder.CloseFile();

Resulting document