Returns the value of the probability density function or the cumulative distribution function for the chi-square distribution.
CHISQDIST(Number; Degrees Of Freedom[; Cumulative])
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, +∞).
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.
The formula for CHISQ.DIST is:
If Cumulative is FALSE, CHISQDIST returns 0 for x<=0 and the value
If Cumulative is TRUE, CHISQDIST returns 0 for x<=0 and the value
Here x is the Number and n is the DegreesFreedom.
For more details on Chi distribution, visit Wikipedia.
|=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:
Equivalent Excel functions: