Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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.

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 .