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

Want to practice WEIBULL.DIST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=WEIBULL.DIST(x, alpha, beta, cumulative) Explain

Arguments

ArgumentRequired?What it does
xYesThe time; can't be negative.
alphaYesThe shape; must be greater than 0.
betaYesThe scale (characteristic life); must be greater than 0.
cumulativeYesTRUE 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.

B4fx=WEIBULL.DIST(500,B2,B3,TRUE)
AB
1MeasureValue
2Shape (alpha)1.5
3Scale (beta)1000
4Failed by 500 h0.2978
5Still working at 1,500 h0.1593
=WEIBULL.DIST(500,B2,B3,TRUE) Explain

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

Kyle Stott

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.