In probability distribution, not only is it required to produce expected results, but it is more complicated to evaluate whether your expected results are valid or not compatible with the original hypothesis. The following article introduces the CHIDIST function - The function returns the right end probability of a distribution when the distribution helps you have a basis to determine the correctness of the expected with the original hypothesis.
Description: The function returns the probability of the right end of a distribution when squared.
Syntax: CHIDIST (x, deg_freedom) .
Inside:
- x : Value to evaluate distribution, is a required parameter.
- deg_freedom : the number of degrees of freedom for x, is a required parameter.
Attention:
- x, deg_freedom: required in numeric format otherwise returns the #VALUE! value.
- Where x The function returns the value #NUM !.
- Where deg_freedom is not an integer => the function takes the integer part of deg_freedom.
- Where deg_freedom 10 => The function returns the value #NUM !.
- CHDIST is calculated by CHDIST = P (X> x) where X is a random variable of χ2.
Example: Calculate the probability value of a distribution with the following data table:
In the cell to calculate, enter the formula: CHDIST (D5, D6) .
Value results:
- Where the degrees of freedom are decimal functions take integers:
The probability value result is equal to the value when the number of degrees of freedom is 32.
- If the number of degrees of freedom is less than 0 => The error function #NUM!
Above is the usage and some special cases when using the CHDIST function. Hope to help you.
Good luck!