Formualizer Docs
ReferenceFunctionsStatistics Functions

WEIBULL.DIST

WEIBULL.DIST: Returns the Weibull-distribution probability at `x` for shape `alpha` and scale `beta`.

Summary

WEIBULL.DIST is commonly used for reliability and time-to-failure analysis.

Remarks

  • Requires x >= 0, alpha > 0, and beta > 0.
  • Set cumulative to non-zero for CDF mode, or 0 for PDF mode.
  • Returns #NUM! when parameters fall outside valid ranges.
  • In PDF mode at x = 0, behavior follows the Weibull shape-specific limit.

Examples

Weibull CDF with alpha=1 and beta=2
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.6321205588285577
Weibull PDF with alpha=1 and beta=2
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.18393972058572117

Runtime metadata

Category

Statistics

Signature

WEIBULL.DIST(arg1: Number, arg2: Number, arg3: Number, arg4: Number)

Arity

min 4, max 4

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

arg4

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

VAR.S

VAR.S: Estimates sample variance using `n-1` in the denominator.

Z.TEST

Z.TEST: Returns the one-tailed p-value of a z-test against hypothesized mean `x`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata