Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure.
Syntax
WEIBULL(x,alpha,beta,cumulative)
X is the value at which to evaluate the function.
Alpha is a parameter to the distribution.
Beta is a parameter to the distribution.
Cumulative determines the form of the function.
Remarks
- If x, alpha, or beta is nonnumeric, WEIBULL returns the #VALUE! error value.
- If x < 0, WEIBULL returns the #NUM! error value.
- If alpha ≤ 0 or if beta ≤ 0, WEIBULL returns the #NUM! error value.
- The equation for the Weibull cumulative distribution function is:
![Equation](helpContent.aspx?id=MS.OSS.awfweib1_ZA06051261&lcid=1033)
- The equation for the Weibull probability density function is:
![Equation](helpContent.aspx?id=MS.OSS.awfweib2_ZA06051262&lcid=1033)
- When alpha = 1, WEIBULL returns the exponential distribution with:
![Equation](helpContent.aspx?id=MS.OSS.awfweib3_ZA06051263&lcid=1033)
Examples
X | Alpha | Beta | Formula |
Description (Result) |
105 | 20 | 100 | =WEIBULL([X],[Alpha],[Beta],TRUE) |
Weibull cumulative distribution function for the specified arguments (0.929581) |
105 | 20 | 100 | =WEIBULL([X],[Alpha],[Beta],FALSE) |
Weibull probability density function for the specified arguments (0.035589) |