WEIBULL
Returns the Weibull distribution.
Syntax
expression.WEIBULL(arg1, arg2, arg3, arg4);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| arg1 | Required | ApiRange | ApiName | number | The value at which to evaluate the function, a nonnegative number. | |
| arg2 | Required | ApiRange | ApiName | number | The alpha parameter of the distribution, a positive number. | |
| arg3 | Required | ApiRange | ApiName | number | The beta parameter of the distribution, a positive number. | |
| arg4 | Required | ApiRange | ApiName | boolean | A logical value (true or false) that determines the function form. If it is true, the function returns the cumulative distribution function. If it is false, the function returns the probability mass function. |
Returns
number
Example
Return the Weibull distribution in a spreadsheet.
// How to return the Weibull distribution in a spreadsheet.
// Use a function to calculate the Weibull distribution in a spreadsheet.
let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
let result = func.WEIBULL(12, 2, 5, true);
worksheet.GetRange("B2").SetValue(result);