WEIBULL.DIST Function
Returns the Weibull distribution — used for product lifetimes and failure rates.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
The Weibull distribution is the standard model for how long things last. alpha (shape) sets how the failure risk changes over time: below 1 means early failures, 1 means a constant risk (the exponential case), above 1 means wear-out. beta (scale) sets the typical lifetime.
TRUE returns the cumulative probability (the chance of a value up to x); FALSE returns the probability density — the height of the curve, not a probability.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The time; can't be negative. |
| alpha | Yes | The shape; must be greater than 0. |
| beta | Yes | The scale (characteristic life); must be greater than 0. |
| cumulative | Yes | TRUE for the cumulative probability, FALSE for the density (height of the curve). |
Examples
Example 1 — Warehouse scanner failures
Scanner life follows a Weibull with shape 1.5 (wear-out) and scale 1,000 hours.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Shape (alpha) | 1.5 |
| 3 | Scale (beta) | 1000 |
| 4 | Failed by 500 h | 0.2978 |
| 5 | Still working at 1,500 h | 0.1593 |
About 30% fail within 500 hours; only about 16% last beyond 1,500.
Common mistakes
- #NUM! x is negative, or alpha or beta is 0 or negative.
Notes
- WEIBULL.DIST replaces the older WEIBULL function.
- Related functions: EXPON.DIST, GAMMA.DIST.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.