WEIBULL.DIST function
WEIBULL.DIST returns the Weibull probability or density, used in reliability work to model time until failure, such as how long a part lasts. Shape and scale are easy to swap.
Example
Read it as a sentence: find the cumulative Weibull probability at the value in D1, using shape 1.5 and scale 3, which gives 0.
Excel shows 0
D
1
Data
Syntax
WEIBULL.DIST(x, alpha, beta, cumulative)
-
x(required) - The value to evaluate; zero or more.
-
alpha(required) - Shape parameter; must be positive.
-
beta(required) - Scale parameter; must be positive.
-
cumulative(required) - TRUE for the cumulative probability, FALSE for density.
Returns: The Weibull probability or density.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=WEIBULL.DIST(2,1.5,3,TRUE) | 0.419770204 | Working example |
=WEIBULL.DIST(2,1.5,3,FALSE) | 0.236877822 | Other cumulative flag |
=WEIBULL.DIST(2,1.5,3,0) | 0.236877822 | Cumulative as 0 |
=WEIBULL.DIST("2",1.5,3,TRUE) | 0.419770204 | Text-number in first arg |
=WEIBULL.DIST({2,2},1.5,3,TRUE) | 0.419770204 | Array in first arg (lifts, spills) |
=WEIBULL.DIST(Data!D1,1.5,3,TRUE) | 0 | Blank cell as first arg |
=WEIBULL.DIST("abc",1.5,3,TRUE) | #VALUE! | Non-numeric text in first arg |
=WEIBULL.DIST(NA(),1.5,3,TRUE) | #N/A | Error in first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- alpha is shape and beta is scale, easy to swap.
- x below 0 gives #NUM!.
Where it works
- Excel
- WEIBULL.DIST arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, but behaves differently: `WEIBULL`. Sheets has WEIBULL and WEIBULL.DIST.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .