F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
The following article introduces you to the F.INV.RT function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the inverse of the right probability distribution F. Support function from Excel 2010 version.
Syntax: F.INV.RT (probability, deg_freedom1, deg_freedom2)
Inside:
- probability: Probability associated with the cumulative distribution F, is a required parameter.
- deg_freedom1: The degree of freedom in the numerator, is a required parameter.
- deg_freedom2: The degrees of freedom in the denominator, are required parameters.
Attention:
- If any parameters are not numeric -> the function returns the #VALUE! Error value .
- If probability <0 or probability> 1 -> the function returns the #NUM! Error value
- If deg_freedom1 , deg_freedom2 are not whole numbers -> they are truncated to integers.
- If deg_freedom1 <1 or deg_freedom2 <1 -> the function returns the #NUM! Error value
For example:
Calculate the value of the right-inverse of the probability distribution F according to the data in the following data table:
- In the cell to calculate, enter the formula : = F.INV.RT (D6, D7, D8)
- Press Enter -> the inverse-right value of probability distribution F is:
- Where the probability associated with the cumulative distribution F > 1 -> the function returns the #NUM! Error value
- If the number of degrees of freedom in the numerator and sample is less than 1 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using F.INV.RT function in Excel.
Good luck!
You should read it
- CHISQ.INV.RT function - The function returns the inverse of the right end probability 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 in Excel
- T.INV function - The function returns the inverse value of the Student t distribution in Excel
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
- NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel
- T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel
- CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
May be interested
- TDIST function - The function returns the probability of the Student distribution in Excelin 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 Excelnorm.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 Excelf.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 Excelf.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 Excelbinom.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)
- CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excelchisq.dist.rt function: the function returns the probability of the right end of the distribution when squared. support function from excel 2010 version. syntax: chisq.dist.rt (x, deg_freedom)
- NORMINV function - The function returns the inverse of the cumulative distribution in Excelthe 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 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])
- TINV function - The function returns the inverse of the Student's t-distribution in Exceltinv function: the tinv function supports the calculation of the inverse value of the student's t-distribution associated with the student's 2-t distribution in excel.
- 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