CHISQ.DIST
Description
Returns the (left-tail) chi square distribution. Depending on the
cumulative
argument, calculates either the probability
density function value or the cumulative distribution function value.
Syntax
CHISQ.DIST(
x
,
deg_freedom
,
cumulative
)
- x: The value to use when evaluating the distribution.
- deg_freedom: The number of degrees of freedom.
- cumulative: The type of distribution to use. FALSE = probability density function; TRUE = cumulative distribution function.
Example
Formula | Result |
|---|---|
=CHISQ.DIST(0.5, 1, TRUE) | 0.520499878 |
=CHISQ.DIST(2, 3, FALSE) | 0.207553749 |
Notes
- This function does the same action as CHISQDIST() and CHIDIST().