Edit

Share via

WorksheetFunction.Weibull_Dist method (Excel)

  • Article

Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating the mean time to failure for a device.

Syntax

expression.Weibull_Dist (Arg1, Arg2, Arg3, Arg4)

expression A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data type Description
Arg1 Required Double X - The value at which to evaluate the function.
Arg2 Required Double Alpha - A parameter to the distribution.
Arg3 Required Double Beta - A parameter to the distribution.
Arg4 Required Boolean Cumulative - Determines the form of the function.

Return value

Double

Remarks

If x, alpha, or beta is non-numeric, Weibull_Dist returns the #VALUE! error value.

If x < 0, Weibull_Dist returns the #NUM! error value.

If alpha ≤ 0 or if beta ≤ 0, Weibull_Dist returns the #NUM! error value.

The equation for the Weibull cumulative distribution function is   Screenshot that shows the equation for the Weibull cumulative distribution function.

The equation for the Weibull probability density function is   Screenshot that shows the equation for the Weibull probability density function.

When alpha = 1, Weibull_Dist returns the exponential distribution with   Screenshot that shows the equation that Weibull returns when alpha equals 1.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.