EXPONDIST

EXPONDIST(arg1, arg2, arg3) → { number }

Returns the exponential distribution.

Parameters:

Name Type Description
arg1 number

The value of the x function, a nonnegative number.

arg2 number

The lambda parameter value, a positive number.

arg3 boolean

A logical value that determines the function form. If this parameter is true, the function will return the cumulative distribution function, if it is false, it will return the probability density function.

Returns:

Type
number

Example

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

Resulting document