EXPONDIST
Returns the exponential distribution.
Syntax
expression.EXPONDIST(arg1, arg2, arg3);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| arg1 | Required | ApiRange | ApiName | number | The value of the x function, a nonnegative number. | |
| arg2 | Required | ApiRange | ApiName | number | The lambda parameter value, a positive number. | |
| arg3 | Required | ApiRange | ApiName | 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
number
Example
This example shows how to return the exponential distribution.
- Code
- Result
// How to get the exponential distribution.
// Use function to calculate an exponential distribution.
let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
let ans = func.F_DIST(10, 6, 4, false);
worksheet.GetRange("B2").SetValue(ans);