Formualizer Docs
ReferenceFunctionsStatistics Functions

NEGBINOM.DIST

NEGBINOM.DIST: Returns negative-binomial probabilities for failures observed before a target success count.

Summary

NEGBINOM.DIST supports exact-failure mode (PMF) and cumulative mode (CDF).

Remarks

  • number_f is truncated and must be >= 0.
  • number_s is truncated and must be >= 1.
  • probability_s must satisfy 0 < p < 1.
  • Returns #NUM! when counts or probability are outside valid ranges.

Examples

Negative binomial PMF
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.125
Negative binomial CDF
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.875

Runtime metadata

Category

Statistics

Signature

NEGBINOM.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

MODE.SNGL

MODE.SNGL: Returns the most frequently occurring value in a data set.

NORM.DIST

NORM.DIST: Returns the normal-distribution probability at `x` for a given mean and standard deviation.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata