EXPONDIST
function EXPONDIST(arg1: number = null, arg2: number = null, arg3: boolean = null): numberDescription
Returns the exponential distribution.
Parameters
- arg1
numberdefault: null The value of the x function, a nonnegative number.
- arg2
numberdefault: null The lambda parameter value, a positive number.
- arg3
booleandefault: null 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
numberTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.F_DIST(10, 6, 4, false);
oWorksheet.GetRange("B2").SetValue(ans);