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
- COUPNCD - The function returns the next coupon date in Excelcurrently, stock investment is no stranger to people, the matter is concerned daily. therefore, the following article introduces the coupncd function in detail to help you calculate the next coupon date.
- COUPPCD - The function returns the previous coupon date before the settlement date in Excelin the previous article introduced to you the function returns the next coupon date after the settlement date. the following article introduces you to the couppcd function - the function returns the previous coupon date before the settlement date.
- CUMPRINC function - The function calculates the cumulative capital amount payable in Excelthe following article shows how to use the cumprinc function to help you calculate by calculating the cumulative capital amount to pay.
- DB function - The function calculates the depreciation of assets with specific maturity in Excelthe following article details the db function - the function of depreciation of assets with specific maturity with the use of the method of calculating the declining balance by fixed level.
- MDURATION function - The function returns the modified term according to Macauley of stock in Excelmduration function - the function returns the macauley modified term of a security with an initial assumption of $ 100 in excel.
- FTEST function - The function returns the result of an F-Test in Excelthe following article details how to use ftest - the function returns the result of an f-test. in statistical probability, the determination of the correctness and the deviation between two data samples is a regular and extremely important job.