WEIBULL

Formulas / WEIBULL
Calculate 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?
The WEIBULL function returns the Weibull distribution, which is used in reliability analysis to calculate the mean time to failure for a device.
What does the WEIBULL.DIST function do?
The WEIBULL.DIST function may provide improved accuracy when calculating the Weibull distribution.
What is the Weibull distribution used for?
The Weibull distribution is used in reliability analysis to calculate a device's mean time to failure.
What is the difference between the WEIBULL and WEIBULL.DIST functions?
The WEIBULL function returns the Weibull distribution, while the WEIBULL.DIST function may provide improved accuracy when calculating the Weibull distribution.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV