MS Excel - Excel CHISQ.DIST() function
Description
The CHISQ.DIST() function is used to get the chi-squared distribution.
The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching movies in television.
Version: Excel 2013
Syntax
CHISQ.DIST(x,deg_freedom,cumulative)
Parameters
| Name | Description | Data Type | Required/ Optional |
|---|---|---|---|
| X | The value at which you want to evaluate the distribution. | number | Required |
| Deg_freedom | The number of degrees of freedom. | number | Required |
| Cumulative | A logical value that determines the form of the function. If cumulative is TRUE, CHISQ.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function. |
boolean | Required |
Remarks :
- If any argument is nonnumeric, CHISQ.DIST returns the #VALUE! error value.
- If x is negative, CHISQ.DIST returns the #NUM! error value.
- If deg_freedom is not an integer, it is truncated.
- If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.DIST returns the #NUM! error value.
Example - 1: Excel CHISQ.DIST() function
In the following example the chi-squared distribution for 0.3, returned as the cumulative distribution function, using 1 degree of freedom.
Example - 2 : The chi-squared distribution for 3, returned as the probability density function, using 1 degrees of freedom.
?
Source:http://www.w3resource.com/excel/excel-chisq-dot-dist-function.php
