ReferenceFunctionsStatistics Functions

CHISQ.INV

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

Summary

CHISQ.INV inverts CHISQ.DIST(x, deg_freedom, TRUE).

Remarks

probability must be strictly between 0 and 1.
deg_freedom must be at least 1.
Returns #NUM! when arguments are outside valid ranges.
Invalid numeric coercions propagate as spreadsheet errors.

Examples

Median chi-square quantile for df=2

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1.3862943611198906

Upper quantile for df=10

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

18.307038053275146

Runtime metadata

Category

Statistics

Signature

CHISQ.INV(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

CHISQ.DIST

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

CHISQ.TEST

CHISQ.TEST: Returns the right-tail p-value from a chi-square goodness-of-fit style comparison.

On this page

Summary Remarks Examples Related functions Runtime metadata