WEIBULL
Formulas / WEIBULLCalculate the Weibull distribution.
WEIBULL(x,alpha,beta,cumulative)
- x - the value to evaluate the function on
- alpha - a parameter to the distribution
- beta - a parameter to the distribution
- cumulative - a parameter to the distribution
Examples
=WEIBULL(A2,A3,A4,TRUE)To find the Weibull cumulative distribution function for the terms in cells A2, A3 and A4, use the preceding formula. This will return the probability that a random variable is less than or equal to the value in cell A2.
=WEIBULL(A2,A3,A4,FALSE)To find the Weibull probability density function for the terms in cells A2, A3 and A4, use the formula above. This will return the probability that a random variable is equal to the value in cell A2.
=WEIBULL(A2,A3,A4,TRUE)For example, if you have a value of 5 in cell A2, a value of 2 in cell A3, and a value of 4 in cell A4, you could use the formula above to find the Weibull cumulative distribution function for these values. This will return the probability that a random variable is less than or equal to 5.
=WEIBULL(A2,A3,A4,FALSE)Similarly, if you have the same values of 5 in cell A2, 2 in cell A3 and 4 in cell A4, you could use the formula above to find the Weibull probability density function for these values. This will return the probability that a random variable is equal to 5.
Summary
The WEIBULL function is used to calculate the Weibull distribution which is commonly used in reliability analysis to estimate a device's mean time to failure.
- The WEIBULL function returns the Weibull distribution, which is used in reliability analysis to calculate a device's mean time to failure.
- The WEIBULL.DIST function may provide improved accuracy when calculating a device's mean time to failure.
Frequently Asked Questions
What is the WEIBULL function?
What does the WEIBULL.DIST function do?
What is the Weibull distribution used for?
What is the difference between the WEIBULL and WEIBULL.DIST functions?
