This function calculates the chi-squared distribution.
CHISQ.DIST(value,deg,cumulative)
This function has these arguments:
| Argument | Description |
|---|---|
| value | Value at which to evaluate the function |
| deg | Number of degrees of freedom; if not an integer, the number is truncated |
| cumulative | A logical value that determines the form of the function. If cumulative is TRUE, this function returns the cumulative distribution function; if FALSE, it returns the probability density function |
Accepts numeric data for value and deg arguments. Returns numeric data.
CHISQ.DIST(B5,D7,TRUE)
CHISQ.DIST(R5C2,R7C4,TRUE)
CHISQ.DIST(6.7,4,TRUE) gives the result 0.8473830596613241
This function is available in Spread for Windows Forms 11.0 or later.