WEIBULL.DIST Function in LibreOffice Calc — Tested Examples

Statistical Intermediate LibreOffice Calc

An explanation of LibreOffice Calc WEIBULL.DIST, including tested formulas, examples, expected results and common mistakes.

Tested: Examples checked in LibreOffice Calc 25.2.3.2. What this means

Returns the values of the Weibull distribution. For shape 2 and scale 3, both the cumulative probability and density at x=0 are zero.

Syntax and arguments

=WEIBULL.DIST(Number; Alpha; Beta; C)

LibreOffice Calc formulas generally separate arguments with semicolons (;).

Argument Explanation
Number The value for which the Weibull distribution is to be calculated.
Alpha The Alpha parameter of the Weibull distribution.
Beta The Beta parameter of the Weibull distribution.
C Cumulated. C=0 calculates the density function, C=1 the distribution.

Worked examples

Example 1: Find cumulative Weibull probability at zero

=WEIBULL.DIST(0;2;3;TRUE())

Expected result: 0. This value was returned in the LibreOffice Calc 25.2 test.

Example 2: Weibull probability density at zero with shape 2

=WEIBULL.DIST(0;2;3;FALSE())

Expected result: 0. This value was returned in the LibreOffice Calc 25.2 test.

How to interpret the result

For shape 2 and scale 3, both the cumulative probability and density at x=0 are zero.

Mistakes and troubleshooting

  • Check inputs and assumptions: Shape and scale parameters must be positive; density mode is different from cumulative mode.
  • Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
  • Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.

COUNT · AVERAGE · SUM

Tested version and primary reference

2 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.