F.INV function - The function returns the inverse of the probability distribution F in Excel
The following article introduces you to F.INV - one of the functions in the group of statistical functions that is very popular in Excel.
Description: The function returns the inverse of the probability distribution F. The support function is from Excel 2010 version.
Syntax: F.INV (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 inverse value of probability distribution F according to the data in the following data table:
- In the cell to calculate enter the formula : = F.INV (D6, D7, D8)
- Press Enter -> the inverse 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 function in Excel.
Good luck!
You should read it
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- 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
- TDIST function - The function returns the probability of the Student distribution in Excel
- F.DIST - The function returns the probability distribution F in Excel
Maybe you are interested
Difference between function and formula in Excel
8 little-known Excel functions that can save you a lot of work
How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
Date functions in Excel, DAY, WEEKDAY, MONTH
How to use the SUMIF function in Excel to calculate the sum based on conditions
How to use the Round function in Excel to round numbers and process data