EXCEL CHIINV FUNCTION
Excel CHIINV Function Introduction
The Excel Chiinv function computes the inverse of the Chi-Square Distribution’s right-tailed probability.
Description of Excel CHIINV Function
Syntax:
=CHIINV( probability, degrees_freedom )
Parameter:
- The function parameters are as follows:
probability:
- The chi-square distribution probability for which you wish to calculate the value of x.
degrees_freedom:
- The number of possible outcomes (must be a positive integer).
(If degrees freedom is specified as a decimal, it is trimmed to an integer.)
Step By Step Guide of CHIINV Function
Example:
The spreadsheet below contains five examples of the Excel Chiinv function, which is used to compute the inverse right-tailed chi-square distribution.
Key Points
- #NUM! – Occurs if either of the following conditions are met: the given probability value is 0 or more than 1; the supplied degrees freedom argument is 1.
- #VALUE!
– This error occurs if any of the given parameters is not a number
Excel CHIINV Function Template/Exercise
Related Functions
Excel Functions
Excel Formulas
Excel Shortcuts
Excel Data Analytics
- AND
- FALSE
- IF
- IFEROR
- IFNA
Excel Resources
- AND
- FALSE
- IF
- IFEROR
- IFNA