# Documentation/Calc Functions/CHISQDIST

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

CHISQDIST

## Category:

Statistical Analysis

## Summary:

Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution.

## Syntax:

CHISQDIST(**Number**; **Degrees Of Freedom**[; **Cumulative**])

## Returns:

Returns a real number which is the chi-square distribution value for the given arguments. The function returns either a probability density function or cumulative distribution function which has a non-negative range, i.e. [0, +∞).

## Arguments:

**Number** is a real number or a reference to the cell containing that number which is the chi-square value of the random sample used to determine the error probability.

**Degrees Of Freedom** is a positive integer or a reference to a cell containing that number which is the degrees of freedom of the experiment.

**Cumulative** can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function.

- If
**Number**is less than or equal to 0, then, for valid values of DegreesFreedom, the function returns 1. - If
**DegreesFreedom**is less than 1, the function returns an error value. - If
**DegreesFreedom**is a non-integer numeric value, then the function truncates it in an integer. - If argument
**Cumulative**is not passed then, the function calculates the cumulative distribution.

## Additional details:

The formula for CHISQ.DIST is:

If **Cumulative** is FALSE, CHISQDIST returns 0 for x<=0 and the value

for x>0.

If **Cumulative** is TRUE, CHISQDIST returns 0 for x<=0 and the value

for x>0

Here x is the **Number** and n is the **DegreesFreedom**.

For more details on Chi distribution, visit Wikipedia.

## Examples:

Formula | Description | Returns |
---|---|---|

=CHISQDIST(3; 2; 0) | The probability density function with 2 degrees of freedom, at Number = 3. |
0.1115650801 |

=CHISQDIST(3; 2; 1) | The cumulative chi-square distribution with 2 degrees of freedom, at the value Number = 3. |
0.7768698399 |

=CHISQDIST(3; 2) | If not Cumulative declared then the function calculates cumulative chi-square distribution. Here it calculates with 2 degrees of freedom, at the value Number = 3. |
0.7768698399 |

=CHISQDIST(-3; 2; 0) | Number is less than 0 hence the function returns 0 for valid values of DegreesFreedom. |
0 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

CHISQDIST