CHISQ.INV function - The function returns the inverse of the probability of the left end 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. Support functions from the Excel 2010 version. Syntax: CHISQ.INV (probability, deg_freedom)

The following article introduces to you the function CHISQ.INV - 1 of the jaw among statistical functions in Excel is preferred.

CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 1CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 1

Description: The function returns the inverse of the probability of the left end of the distribution when squared. Support function from Excel 2010 version.

Syntax: CHISQ.INV (probability, deg_freedom)

Inside:

- probability: Probability associated with the distribution when the square of the distribution.

- deg_freedom: Number of degrees of freedom.

Attention:

- If any of the parameters' values ​​are not numeric -> the function returns the #VALUE! Error value .

- If deg_freedom is not an integer -> it is truncated to an integer.

- If probability <0 or probability> 1 -> the function returns the #NUM! Error value

- If deg_freedom <1 or deg_freedom> 10 ^ 10 -> the function returns the #NUM! Error value

For example:

Calculate the inverse of the probability of the left end when the square of the distribution is based on the data in the table below:

CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 2CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 2

- In the cell to calculate enter the formula: = CHISQ.INV (C6, C7)

CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 3CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 3

- Press Enter -> the inverse of the probability of the left end of the distribution when the square is:

CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 4CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 4

- Case 1 of the values ​​of non-left parameters is number -> the function returns the error value #VALUE!

CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 5CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 5

- If the number of degrees of freedom is less than 1 or greater than 10 ^ 10 -> the function returns the #NUM! Error value

CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 6CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel Picture 6

Above are instructions and some specific examples when using the CHISQ.INV function in Excel.

Good luck!

5 ★ | 1 Vote