Buzz
When dealing with probability distributions, evaluating the alignment of expected outcomes with the initial hypothesis is crucial. Introducing CHIDIST Function - A tool to assess the validity of expectations against the initial hypothesis.
Description: Returns the right-tail probability of a chi-squared distribution.
Syntax: CHIDIST(x,deg_freedom).
In the mix:
- x: The value under scrutiny for distribution, it's a compulsory parameter.
- deg_freedom: Degrees of freedom for x, a compulsory parameter.
Note:
- x, deg_freedom: required in numerical format otherwise the function returns #VALUE!.
- When x <0 => Function returns #NUM!.
- If deg_freedom is not an integer => function takes the integer part of deg_freedom.
- If deg_freedom <1 and deg_freedom>10 => Function returns #NUM!.
- The CHDIST function is calculated as CHDIST= P(X>x) where X is the random variable of χ2.
Example: Compute the probability value of the distribution with the following dataset:
In the cell to calculate enter the formula: CHDIST(D5,D6).
Result value:
- If the degrees of freedom is a decimal, the function takes the integer part:
Result probability value equals the value when the degrees of freedom is 32.
- If the degrees of freedom is less than 0 => function returns error #NUM!
Above is the usage and some special cases when using the CHDIST function. Hope it will be helpful for you all.
Wishing you all success!
