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
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- FISHER function - The function returns the Fissher transformation at x in Excelfisher function: the function returns the fissher transformation at x. this transformation creates a normal distribution function, using this function to test a hypothesis based on a correlation coefficient. syntax: fisher (x)
- FISHERINV function - Function that returns the inverse of the Fissher transformation in Excelfisherinv function: the function returns the inverse of the fissher transformation. use this function to analyze the correlation between two data arrays, if y = fisher (x) -> fisherinv (y) = x. syntax: fisher (y)
- FORECAST function - The function returns a value along a linear trend in Excelforecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)
- FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excelfrequency function: function that calculates and returns the frequency of occurrences of values within a certain range and returns a vertical number array. syntax: frequency (data_array, bins_array)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)