Formualizer Docs
ReferenceFunctionsStatistics Functions

CHISQ.DIST

CHISQ.DIST: Returns the chi-square probability for `x` with the specified degrees of freedom.

Summary

Use CHISQ.DIST in cumulative mode for left-tail probability or density mode for the PDF.

Remarks

  • Set cumulative to non-zero for CDF mode, or 0 for PDF mode.
  • Requires x >= 0 and deg_freedom >= 1.
  • Returns #NUM! for negative x or invalid degrees of freedom.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Chi-square CDF at zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0
Chi-square PDF example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.18393972058572117

Runtime metadata

Category

Statistics

Signature

CHISQ.DIST(arg1: Number, arg2: Number, arg3: Number)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

BINOM.DIST

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

CHISQ.INV

CHISQ.INV: Returns the chi-square value whose left-tail probability is `probability`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata