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

CHISQ.INV.RT function - The function returns the inverse of the right end probability 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

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 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 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 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 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 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 6

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

Good luck!

Marvin Fry

Update 19 May 2020

You should read it

May be interested

CHISQ.DIST - Function returns the distribution when squared in Excel
chisq.dist: the function returns the distribution when squared, and this value is often used to understand variations as a percentage of the samples. support function from excel 2010 version. syntax: chisq.dist (x, deg_freedom, cumulative)
LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel
lognorm.inv: the function returns the inverse of the logarithmic distribution of x. where ln (x) is usually distributed with parameter mean and standard deviation. use functions to analyze logarithmic change data. support function from excel 2 version
TDIST function - The function returns the probability of the Student distribution in Excel
in probability statistics, calculating probability is a regular job and puts a lot of pressure on you. the following article introduces the tdist function in detail to help you calculate the probability value of the student distribution.
NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel
norm.s.inv function: the function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1. support from excel 2010 onwards. syntax: norm.s.inv (probability)
F.DIST - The function returns the probability distribution F in Excel
f.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel
f.dist.rt function: the function returns the right probability distribution f for 2 data sets. support functions from the excel 2010 version. syntax: f.dist (x, deg_freedom1, deg_freedom2)
BINOM.DIST function - Function returns the probability of binomial distribution of individual terms in Excel
binom.dist function: the function returns the binomial distribution probability of an individual term. support functions from the excel 2010 version. syntax: binom.dist (number_s, trials, probability_s, cumulative)
T.DIST - The function returns the Student t-distribution on the left in Excel
t.dist: the function returns the student's t-distribution on the left. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist (x, deg_freedom, cumulative)
NORMINV function - The function returns the inverse of the cumulative distribution in Excel
the following article details how to use the norminv function - the function returns the inverse of the cumulative distribution in excel.
BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel
binom.dist.range function: the function returns the probability of a test result using binomial distribution. support functions from the excel 2010 version. syntax: binom.dist.range (trials, probability_s, number_s, [number_s2])

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

You should read it

May be interested

Office information