The F.INV.RT function is used to calculate the inverse of the F probability distribution. It provides the value at which an F-distribution cumulative probability is met.


=F.INV.RT(probability, degrees_freedom1, degrees_freedom2)

probability The probability at which you want to evaluate the F-distribution.
degrees_freedom1 The number of degrees of freedom in the numerator.
degrees_freedom2 The number of degrees of freedom in the denominator.

About F.INV.RT

When diving into statistical analysis and scrutinizing the F-distribution, Microsoft Excel's F.INV.RT function steps in as a handy tool for determining critical values. This function aids in extracting the precise value at which the cumulative F-distribution probability is achieved, allowing for insightful interpretations of statistical significance and variance in data sets. By leveraging F.INV.RT, you gain the ability to make informed decisions based on the probabilities associated with the F-distribution, contributing to the accuracy of statistical evaluations within your spreadsheets.


If you are analyzing an F-distribution with 3 and 5 degrees of freedom for the numerator and denominator respectively, and you wish to find the value at which the probability of 0.05 is met, the F.INV.RT formula would be: =F.INV.RT(0.05, 3, 5). This will return the critical value for the specified F-distribution probability.


What is the main purpose of the F.INV.RT function?

The F.INV.RT function is primarily used to determine the critical values of the F-distribution based on specified probabilities and degrees of freedom, aiding in statistical analysis and hypothesis testing.

Can the F.INV.RT function handle probabilities outside the range of 0 to 1?

No, the F.INV.RT function requires the probability argument to be within the range of 0 to 1 for accurate evaluation of the F-distribution.

How crucial are the degrees of freedom parameters in the F.INV.RT function?

The degrees of freedom parameters (degrees_freedom1 and degrees_freedom2) play a pivotal role in defining the F-distribution and are essential for obtaining the correct critical value in statistical analysis.

Related functions