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
How to turn a photo into a painting using the Generative Fill function in Photoshop
How to use the TREND function in Excel
Google Sheets Functions to Simplify Your Budget Spreadsheets
Instructions for using the TRIMRANGE function to clean up Excel tables
How to master numerical data in Google Sheets with the AVERAGE function
Don't buy headphones if they lack this important function!