CHISQ.INV.RT DAX Function (Statistical)

Returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHISQ.DIST.RT(x,…), then CHISQ.INV.RT(probability,…) = x. Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is valid.

Syntax

CHISQ.INV.RT ( <Probability>, <Deg_freedom> )
Parameter Attributes Description
Probability

A probability associated with the chi-squared distribution.

Deg_freedom

The number of degrees of freedom.

Return values

Scalar A single decimal value.

Returns the inverse of the right-tailed probability of the chi-squared distribution.

Remarks

If either argument is nonnumeric, CHISQ.INV.RT returns the #VALUE! error value.

If probability < 0 or probability > 1, CHISQ.INV.RT returns the #NUM! error value.

If deg_freedom is not an integer, it is rounded.

If deg_freedom < 1, CHISQ.INV.RT returns the #NUM! error value.

Given a value for probability, CHISQ.INV.RT seeks that value x such that CHISQ.DIST.RT(x, deg_freedom) = probability. Thus, precision of CHISQ.INV.RT depends on precision of CHISQ.DIST.RT. CHISQ.INV.RT uses an iterative search technique. If the search has not converged after 64 iterations, the function returns the #N/A error value.

Related functions

Other related functions are:

Last update: Oct 20, 2018   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

DAX Conventions
Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

Row Context

This expression is executed in a Row Context. Click to read more.

Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

Not recommended

The use of this parameter is not recommended.

Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

Deprecated

This parameter is deprecated and its use is not recommended.

Contribute

Want to improve the content of CHISQ.INV.RT? Did you find any issue? Please, report it us!
All submissions will be evaluated for possible updates of the content.