Excel functions / Statistics
WEIBULL.DIST function
The Weibull distribution, used for how long things last before they fail.
Syntax
=WEIBULL.DIST(x, alpha, beta, cumulative)
Arguments
x: The value, 0 or more.alpha: The shape of the distribution.beta: Its scale.cumulative: TRUE for the chance of x or less; FALSE for the height of the curve at x.
When to use it
WEIBULL.DIST gives the chance that something fails by time x (with TRUE), for lifetimes that follow a Weibull distribution, common in reliability work.
Examples
Failed by 105 hours, shape 20, scale 100
A B C D E 1 Hours Shape Scale 2 105 20 100 0.9296 In E2:
=WEIBULL.DIST(A2, B2, C2, TRUE)→ 0.9296
Common mistakes
- Shape 1. With a shape of 1 the Weibull is the exponential distribution.
WEIBULL.DIST in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: WEIBULL.DIST
- Danish: WEIBULL.FORDELING
- Dutch: WEIBULL.VERD
- Finnish: WEIBULL.JAKAUMA
- French: LOI.WEIBULL.N
- German: WEIBULL.VERT
- Hungarian: WEIBULL.ELOSZLÁS
- Italian: DISTRIB.WEIBULL
- Norwegian: WEIBULL.DIST.N
- Polish: ROZKŁ.WEIBULL
- Portuguese (Brazil): DIST.WEIBULL
- Portuguese (Portugal): DIST.WEIBULL
- Russian: ВЕЙБУЛЛ.РАСП
- Spanish: DISTR.WEIBULL
- Swedish: WEIBULL.FÖRD
- Turkish: WEIBULL.DAĞ
Also written as WEIBULL.
Try WEIBULL.DIST in the playground
Related functions
- EXPON.DIST: The exponential distribution, for the time between events that happen at a steady rate: the chance of waiting x or less.
- GAMMA.DIST: The gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.