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!