- 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
Compatibility - CHIDIST Function
The CHIDIST function replaces the CHISQ.DIST.RT function from Excel 2010.
Description
The function returns the right-tailed probability of the chi-squared distribution. The X2 distribution is associated with a X2 test. Use the X2 test to compare the observed and the expected values. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.
Syntax
CHIDIST(x,deg_freedom)
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 |
Notes
CHIDIST is calculated as CHIDIST = P(X > x), where X is a X2 random variable.
If deg_freedom is not an integer, it is truncated.
If either argument is nonnumeric, CHIDIST returns the #VALUE! error value.
If x is negative, CHIDIST returns the #NUM! error value.
If deg_freedom < 1 or deg_freedom > 10^10, CHIDIST returns the #NUM! error value.
Example
advanced_excel_compatibility_functions.htm
Advertisements