Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.
CHISQ.DIST(3.45, 2, TRUE)
CHISQ.DIST(A2, B2, TRUE)
CHISQ.DIST(x, degrees_freedom, cumulative)
x- The input to the chi-squared probability distribution function. The value at which to evaluate the function.
Must be a positive number.
degrees_freedom- The number of degrees of freedom of the distribution.
cumulative- Logical value that determines the form of the function.
TRUE: CHI.DISTreturns the left-tailed cumulative distribution function.
FALSE: CHI.DISTreturns the probability density function.
degrees_freedomis truncated to an integer if a non-integer is provided.
degrees_freedommust be at least
1and may not exceed
degrees_freedommust be numeric.
CHIDIST: Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.
CHIINV: Calculates the inverse of the right-tailed chi-squared distribution.
CHISQ.DIST.RT: Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.
CHITEST: Returns the probability associated with a Pearson's chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution.
GAMMADIST: Calculates the gamma distribution, a two-parameter continuous probability distribution.
Suppose you want to test the fairness of a 6-sided die:
From several rolls, you obtain a chi-squared statistic of
The number of degrees of freedom is
6 - 1 = 5.
We will evaluate the chi-squared distribution with
5degrees of freedom when x equals
|3||12.3||5||=CHISQ.DIST(12.3, 5, FALSE)|
|4||12.3||5||=CHISQ.DIST(A2, B2, FALSE)|