WEIBULL_DIST

Returns the Weibull distribution.

Syntax

expression.WEIBULL_DIST(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?

// Determine the cumulative or probability density for Weibull distribution in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
let result = func.WEIBULL_DIST(12, 2, 5, true);
worksheet.GetRange("B2").SetValue(result);