Practice free

WEIBULL function

WEIBULL returns a Weibull-distribution value, used in reliability work to model time to failure. It is a compatibility function, so use WEIBULL.DIST in new workbooks.

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(x, alpha, beta, cumulative)

x (required)
Value, 0 or more.
alpha (required)
Shape parameter.
beta (required)
Scale parameter.
cumulative (required)
TRUE for cumulative, FALSE for density.

Returns: A Weibull-distribution value.

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(2,1.5,3,TRUE) 0.419770204 Working example
=WEIBULL(2,1.5,3,FALSE) 0.236877822 Other cumulative flag
=WEIBULL(2,1.5,3,0) 0.236877822 Cumulative as 0
=WEIBULL("2",1.5,3,TRUE) 0.419770204 Text-number in first arg
=WEIBULL({2,2},1.5,3,TRUE) 0.419770204 Array in first arg (lifts, spills)
=WEIBULL(Data!D1,1.5,3,TRUE) 0 Blank cell as first arg
=WEIBULL("abc",1.5,3,TRUE) #VALUE! Non-numeric text in first arg
=WEIBULL(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

  • Superseded by WEIBULL.DIST; use that in new workbooks.

Where it works

Excel
WEIBULL is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
Google Sheets
Same name, same behaviour for everyday use.

Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .