Formualizer Docs
ReferenceFunctionsStatistics Functions

BETA.DIST

BETA.DIST: Returns the beta-distribution probability for `x`, with optional lower/upper bounds.

Summary

BETA.DIST can evaluate either the cumulative probability or density on [A, B] (default [0, 1]).

Remarks

  • Requires alpha > 0, beta > 0, and A < B.
  • x must lie within the inclusive interval [A, B].
  • Set cumulative to non-zero for CDF mode, or 0 for PDF mode.
  • Returns #NUM! for invalid bounds, parameters, or out-of-range x.

Examples

Uniform beta CDF on [0,1]
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.3
Uniform beta PDF on [0,1]
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1

Runtime metadata

Category

Statistics

Signature

BETA.DIST(arg1: Number, arg2: Number, arg3: Number, arg4: Number, arg5: Number, arg6…: Number)

Arity

min 4, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

arg4

Number · Scalar · coercion NumberLenientText

arg5

Number · Scalar · coercion NumberLenientText

arg6

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

AVEDEV

AVEDEV: Returns the average of absolute deviations from the mean.

BINOM.DIST

BINOM.DIST: Returns the binomial probability for a count of successes across independent trials.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata