CHISQ.INV.RT()/CHIINV()
Note
In Excel 2010, the CHIINV() function was replaced with the CHISQ.INV.RT() function, and the CHISQ.INV() function was added to increase the accuracy of the results. To ensure the backward compatibility of CHISQ.INV.RT(), the CHIINV() function is still available.
Syntax. CHISQ.INV.RT(probability,degrees_freedom)
Definition. This function returns the inverse of the right-tailed probability of the chi-square distribution. If probability = CHISQ.DIST.RT(x,...) then CHI.INV(probability,...) = x. Use this function to compare the observed results with the expected results in order to decide whether your original hypothesis is valid.
Arguments
probability (required). A probability associated with the χ2-distribution
degrees_freedom ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
