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
Calculate the Weibull distribution for statistical analysis in a spreadsheet.
// How do I compute the Weibull distribution for probability calculations in a spreadsheet?
// Evaluate the Weibull probability distribution with specific parameters in a spreadsheet.
let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
let result = func.WEIBULL(12, 2, 5, true);
worksheet.GetRange("B2").SetValue(result);