CHIDIST function - Function returns the right end probability of the distribution when squared in Excel

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.

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:

CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 1CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 1

In the cell to calculate, enter the formula: CHDIST (D5, D6) .

CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 2CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 2

Value results:

CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 3CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 3

- Where the degrees of freedom are decimal functions take integers:

CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 4CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 4

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!

CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 5CHIDIST function - Function returns the right end probability of the distribution when squared in Excel Picture 5

Above is the usage and some special cases when using the CHDIST function. Hope to help you.

Good luck!

4 ★ | 1 Vote