What is Chiinv function in Excel?
What is Chiinv function in Excel?
Description. The Microsoft Excel CHIINV function returns the inverse of the one-tailed probability of the chi-squared distribution. The CHIINV function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.
What is Chiinv?
CHIINV(p, df) is the inverse function for CHIDIST(x, df). For any particular x, CHIDIST(x, df) returns the probability that a Chi-Square-distributed random variable with df degrees of freedom is greater than or equal to x. The CHIINV(p, df) function returns the value x where CHIDIST(x, df) returns p.
What does Chisq Inv RT mean?
INV. RT Function. Calculates the inverse of the right-tailed probability of a chi-square distribution.
What is the degrees of freedom for chi-square test?
The degrees of freedom for the chi-square are calculated using the following formula: df = (r-1)(c-1) where r is the number of rows and c is the number of columns.
What happened to the chiinv function in Excel?
In Excel 2010, the Chiinv function has been replaced by the Chisq.Inv.Rt function, which has improved accuracy. Although it has been replaced, the Chiinv function is still available in Excel 2010 (stored in the list of compatibility functions), to allow compatibility with earlier versions of Excel.
How to calculate the inverse of the chi-square distribution in Excel?
The Excel Chiinv function calculates the inverse of the right-tailed probability of the Chi-Square Distribution. The syntax of the function is: CHIINV( probability, degrees_freedom ) Where the function arguments are: The number of degrees of freedom (must be a positive integer).
How does the precision of chiinv depend on the accuracy of chidist?
Thus, precision of CHIINV depends on precision of CHIDIST. CHIINV uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet.
