Buzz
Explore the F.INV function: One of the key statistical functions widely embraced in Excel.
Description: Returns the inverse value of the F probability distribution. Function supported from Excel 2010 onward.
Syntax: F.INV(probability, deg_freedom1, deg_freedom2)
Breakdown:
- probability: The probability linked to the F cumulative distribution, a mandatory parameter.
- deg_freedom1: Degrees of freedom in the numerator, a mandatory parameter.
- deg_freedom2: Degrees of freedom in the denominator, a mandatory parameter.
Note:
- If any parameter is not a number -> the function returns an error value #VALUE!
- If probability < 0 or probability > 1 -> the function returns an error value #NUM!
- If deg_freedom1, deg_freedom2 are not integers -> they are truncated to integers.
- If deg_freedom1 < 1 or deg_freedom2 < 1 -> the function returns an error value #NUM!
Example:
Calculate the inverse value of the F probability distribution based on the data in the table below:
- In the cell where you want to calculate, enter the formula: =F.INV(D6,D7,D8)
- Press Enter -> the inverse value of the F probability distribution is:
- In the case where the probability is associated with the cumulative distribution F ≥ 1 -> the function returns an error value #NUM!
- In the case where the degrees of freedom in the numerator and denominator are less than 1 -> the function returns an error value #NUM!
Here is the guide and some specific examples when using the F.INV function in Excel.
Wishing you all success!
