Syntax
CHISQDIST( <number>, <number>; <boolean>)
Description
Returns a chi square distribution at a given value x for a certain number of degrees of freedom, or returns the chi square density function or the cumulative distribution function for the chi square distribution. This function is frequently used used to measure the degree of diversity between two data sets.
The function arguments are:
- x: The value at which to evaluate the distribution (NUMERIC)
- df: The number of degrees of freedom (NUMERIC)
- Cumulative: Constant indicating the form of the function. If true, then the cumulative distribution function is used. If false, then the probability mass function is used (BOOLEAN)
| Cumulative/Boolean | Logical argument which defines the type of distribution to be calculated |
|---|---|
| True | Uses the cumulative distribution function |
| False | uses the probability density function |
Examples
CHISQDIST(#sheet!VALUE; #sheet!DF; cumulative value)
VALUE | DF | Cumulative value | CHISQDIST returns |
|---|---|---|---|
| 3 | 2 | false | 0.1115 |
| 3 | 2 | true | 0.7768 |
Common Errors
| #NUM! | - | Occurs if either:
|
| #VALUE! | - | Occurs if the argument type isn't numeric |