CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
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!
You should read it
- CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel
- CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel
- CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel
- F.INV function - The function returns the inverse of the probability distribution F in Excel
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
- CHISQ.DIST - Function returns the distribution when squared in Excel
- TDIST function - The function returns the probability of the Student distribution in Excel
- F.DIST - The function returns the probability distribution F in Excel
- F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel
- BINOM.DIST function - Function returns the probability of binomial distribution of individual terms in Excel
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
Maybe you are interested
AMD has surpassed Intel in brand value
SQL way to count NULL and NOT NULL values in a column
Comparing Odroid-N2+ and Raspberry Pi 4: Which option offers better value?
How to receive free gifts from IObit with a total value of nearly 150,000 USD
Write a program to find duplicate values in Python
Write a program to check duplicate values in Python