|
CHISQ.INV |
  
|
|
CHISQ.INV |
|
This function calculates the inverse of the left-tailed probability of the chi-squared distribution.
Syntax
CHISQ.INV(prob,deg)
Arguments
This function has these arguments:
Argument |
Description |
prob |
Probability of the chi-squared distribution |
deg |
Number of degrees of freedom; if not an integer, the number is truncated |
Remarks
If the argument is nonnumeric, the function returns the #VALUE! error value.
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
CHISQ.INV(B5,D7)
CHISQ.INV(R5C2,R7C4)
CHISQ.INV(0.75,4) gives the result 5.385269057779394