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
| Row | A |
|---|---|
| 6 | Input |
| 7 | 1 |
| 8 | 3 |
| 9 | 6 |
=WEIBULL(A7,2,3,TRUE)Illustrative output0.1051606832
See the inputs and instructions for all 3 examplesSyntax
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 |