BETAINV

Returns the inverse of the cumulative beta probability density function for a specified beta distribution (BETADIST).

Syntax

expression.BETAINV(arg1, arg2, arg3, arg4, arg5);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange | ApiName | number		A probability associated with the beta distribution.
arg2	Required	ApiRange | ApiName | number		The alpha parameter of the distribution which must be greater than 0.
arg3	Required	ApiRange | ApiName | number		The beta parameter of the distribution which must be greater than 0.
arg4	Optional	ApiRange | ApiName | number		An optional lower bound to the interval of x (A). If omitted, it is equal to 0.
arg5	Optional	ApiRange | ApiName | number		An optional upper bound to the interval of x (B). If omitted, it is equal to 1.

Returns

number

Example

• Code
• Result

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.BETAINV(0.2, 4, 5));