CHISQ.DIST

Formulas / CHISQ.DIST
Return the chi-squared distribution.
=CHISQ.DIST(x,deg_freedom,cumulative)
  • x - the value to evaluate the distribution from
  • deg_freedom - the number of degrees of freedom
  • cumulative - determines the form of the function

Examples

  • =CHISQ.DIST.RT(A2,A3)

    To use the CHISQ.DIST function to calculate the one-tailed probability of the chi-squared distribution for the arguments specified in A2 and A3, you would enter the formula above in a Sourcetable cell. This will return the one-tailed probability of the chi-squared distribution for the arguments specified in A2 and A3.


Summary

The CHISQ.DIST function calculates the chi-squared distribution, used to study variation in percentages in samples. It requires three arguments, and returns an error if any argument is not numeric.

  • The CHISQ.DIST function takes three arguments which are required: X, deg_freedom, and cumulative.
  • The chi-squared distribution is used to analyze variation in the percentage of something in samples.

Frequently Asked Questions

What is the CHISQ.DIST function?
The CHISQ.DIST function calculates the chi-squared distribution, which is commonly used to study variation in the percentage of something across samples.
What is the chi-squared distribution used for?
The chi-squared distribution is used to determine whether samples are statistically different.
What errors does the CHISQ.DIST function throw?
  • The CHISQ.DIST function throws a #NUM! error if x is negative.
  • The CHISQ.DIST function throws a #VALUE! error if any argument is not a number.
  • The CHISQ.DIST function throws a #NUM! error if deg_freedom < 1 or deg_freedom > 10^10.

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