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.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
May be interested
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excelgamma.inv: the function returns the inverse of the gamma distribution, using this function to study their distribution variables that may be symmetrical. support functions from excel 2010 onwards. syntax: gamma.inv (probability, alpha, beta)
- BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excelbinom.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])
- T.INV function - The function returns the inverse value of the Student t distribution in Excelt.inv: the function returns the inverse value of the student t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excelbeta.inv function: the function returns the inverse of the cumulative distribution function for a specified beta distribution. support functions from excel 2010 version. syntax: beta.inv (probability, alpha, beta, [a], [b])
- NEGBINOM.DIST function - Function returns the negative binomial distribution in Excelnegbinom.dist: the function returns the negative binomial distribution, the probability that there will be number_f failures before the number_s th success, with the probability of success being probability_s. support functions from excel 2010 onwards. syntax: negbinom.dist (number_f, number_s, probab
- T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excelt.inv.2t: the function returns the two-sided inverse of the student's t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
- CHISQ.TEST function - The function returns the independence test in Excelchisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
- NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excelnorm.inv function: the function returns the inverse of the standard cumulative distribution with the standard deviation and the specified mean. support functions from excel 2010 onwards. syntax: norm.inv (probability, mean, standard_dev)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
- ZTEST function - Returns the probability value on one side of the z test in Excelztest function: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.