Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

CHISQ.INV

Calculates the inverse of the left-tailed chi squared distribution.

Sample Usage

CHISQ.INV(0.9,1)
CHISQ.INV(C5,C6)

Syntax

CHISQ.INV(probability, degrees_freedom)

  • probability - The probability associated with the left-tailed chi-squared distribution.
  • degrees_freedom - An integer indicating the degrees of freedom of the distribution.

 

Examples

CHISQ.INV(0.9,1) returns a value of 2.7055, the inverse of the left-tailed probability of the chi-squared distribution for 0.9, using 1 degree of freedom.

Notes

  • degrees_freedom is truncated to an integer if a non-integer is provided.
  • degrees_freedom must be at least 1.
  • All arguments must be numeric.