LOG IN

Forgot Your Password?


Incorrect login or password

SIGN UP



Existing user?

Forgot Password


Existing user?

Excel CHISQ.INV.RT() function

Description

The CHISQ.INV.RT() function is used to get 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.

Version: Excel 2013

Syntax

CHISQ.INV.RT(probability,deg_freedom)

Parameters

Name Description Data Type Required/
Optional
Probability A probability associated with the chi-squared distribution. number Required
Deg_freedom The number of degrees of freedom. number Required

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 truncated.
  • 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.

Example : Excel CHISQ.INV.RT() function
The following worksheet shows the inverse of the one-tailed probability of the chi-squared distribution.

Data Description
0.06 Probability associated with the chi-squared distribution
10 Degrees of freedom

chisq dot inv dot rt



 

 

Source:http://www.w3resource.com/excel/excel-chisq-dot-inv-dot-rt-function.php


 << Previous  Next >>