CHIDIST

Formulas / CHIDIST
Calculate the one-tailed probability of the chi-squared distribution for a given γ2 test.
CHIDIST(x,degrees_freedom)
  • x - the value at which to evaluate the distribution
  • deg_freedom - [OPTIONAL] the degrees of freedom

Examples

  • =CHIDIST(A2,A3)

    For example, if we have data points A2 and A3, and we want to know the one-tailed probability of the chi-squared distribution for those two points, we can use the Sourcetable function. This will return the one-tailed probability of the chi-squared distribution for those two points.

Summary

The CHIDIST function is used to calculate the one-tailed probability of the chi-squared distribution for a γ2 test. Note that the function does not work if degrees_freedom is less than 1 or is 10^10.

  • The CHIDIST function calculates the probability of the chi-squared distribution and is used for a γ2 test.
  • The CHIDIST function returns the #VALUE! error value if either argument is not a number.
  • The CHIDIST function truncates degrees_freedom if degrees_freedom is not an integer.


Frequently Asked Questions

What is the CHIDIST function?
The CHIDIST function calculates the one-tailed probability of the chi-squared distribution.
What is the chi-squared distribution used for?
The chi-squared distribution is used in a γ2 test, which compares observed and expected values.
What errors are thrown by the CHIDIST function?
  • The #VALUE! error is thrown if either argument is not numerical.
  • The #NUM! error is thrown if x is negative.
  • The degrees_freedom argument is truncated if it is not an integer.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.