ExcelFlux

WEIBULL function

Calculation — variance based on the entire population, including numbers, text, and logical values.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Measure failure probability by a given time, using shape two and scale three.

A worked example from the workbook

RowA
6Input
71
83
96
Record 1
=WEIBULL(A7,2,3,TRUE)

Illustrative output0.1051606832

See the inputs and instructions for all 3 examples

Syntax

WEIBULL(x,alpha,beta,cumulative)

Compatibility function for older workbooks.

Worked examples

Measure failure probability by a given time, using shape two and scale three.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 1
8 3
9 6
Trial Expression Sample output
Record 1 =WEIBULL(A7,2,3,TRUE) 0.1051606832
Record 2 =WEIBULL(A8,2,3,TRUE) 0.6321205588
Record 3 =WEIBULL(A9,2,3,TRUE) 0.9816843611
Microsoft Excel reference