CHISQ.DIST function
CHISQ.DIST(X,
DegreesOfFreedom, IsCumulative) CHISQ.DIST(X;
DegreesOfFreedom; IsCumulative)
X
Number or { Number }
A value at which to evaluate the function.
DegreesOfFreedom
Number or { Number }
The degrees of freedom for the distribution.
IsCumulative
Logical or { Logical }
FALSE to calculate the probability density function and TRUE to calculate the cumulative distribution function.
Returns
Number or { Number }
A value for a chi-squared distribution.
Returns a value for a chi-squared distribution.
Examples
CHISQ.DIST(2.3, 15,
FALSE)CHISQ.DIST(2,3; 15;
FALSE)
Returns roughly 0.00021.
CHISQ.DIST(2.3, 2,
FALSE)CHISQ.DIST(2,3; 2;
FALSE)
Returns roughly 0.16.
CHISQ.DIST(1.5, 2,
TRUE)CHISQ.DIST(1,5; 2;
TRUE)
Returns roughly 0.53.
CHISQ.DIST(18, 15,
TRUE)CHISQ.DIST(18; 15;
TRUE)
Returns roughly 0.74.