CHISQ.DIST Function Explained
The CHISQ.DIST Function in Microsoft Excel calculates the cumulative probability of a chi-squared distribution with a given number of degrees of freedom. It takes two arguments: x (the value at which to evaluate the distribution) and deg_freedom (the number of degrees of freedom). The function returns the probability that a chi-squared random variable with deg_freedom degrees of freedom is less than or equal to x.
CHISQ.DIST Function Syntax
CHISQ.DIST(x,deg_freedom,cumulative)
- x: The value at which you want to evaluate the distribution.
- deg_freedom: The number of degrees of freedom.
- cumulative: A logical value that determines the form of the function. If cumulative is TRUE, CHISQ.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.