CHISQ.INV

Formulas / CHISQ.INV
Return the inverse of the left-tailed probability of the chi-squared distribution.
=CHISQ.INV(probability,deg_freedom)
  • probability - probability associated with the chi-squared distribution
  • deg_freedom - number of degrees of freedom

Examples

  • CHISQ.INV(0.6, 2)

    For example, if we want to calculate the critical value for a chi-squared test with 2 degrees of freedom, we can use the function, which will return the critical value for a 0.6 left-tailed probability.


Summary

The CHISQ.INV function calculates the inverse of the left-tailed probability of the chi-squared distribution which is used to measure variation in the percentage of something across samples. It throws errors if the argument is not numeric or is negative or larger than 1.

  • The CHISQ.INV function computes the inverse of the left-tailed probability of the chi-squared distribution, which can be used to study how the percentage of something varies across samples.
  • An example of how to use the chi-squared distribution is for calculating what fraction of the day people watch television.

Frequently Asked Questions

What is the CHISQ.INV function?
The CHISQ.INV function is a statistical function used to calculate the inverse of the left-tailed probability of the chi-squared distribution. It is often used to study variation in the percentage of something across samples.
What is the syntax of the CHISQ.INV function?
The syntax of the CHISQ.INV function is CHISQ.INV(probability,deg_freedom). The first argument is the probability, which is required and should be a probability associated with the chi-squared distribution. The second argument is the number of degrees of freedom, which is also required.
What errors does the CHISQ.INV function throw?
  • #VALUE! error if argument is not numeric
  • #NUM! error if probability is not between 0 and 1
  • #NUM! error if deg_freedom is less than 1

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV