- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - CHISQ.DIST Function
Description
The CHISQ.DIST function returns 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 television.
Syntax
CHISQ.DIST(x,deg_freedom,cumulative)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| X | The value at which you want to evaluate the distribution. | Required |
| Deg_freedom | The number of degrees of freedom | Required |
| Cumulative | A logical value that determines the form of the function. If cumulative is TRUE, CHISQ.DIST returns the cumulative distribution function. If cumulative is FALSE, CHISQ.DIST returns the probability density function. |
Required |
Notes
If deg_freedom is not an integer, it is truncated.
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 < 1 or deg_freedom > 10^10, CHISQ.DIST returns the #NUM! error value.
Applicability
Excel 2010, Excel 2013, Excel 2016
Example
