In Excel 2010, the FINV() function was replaced with the F.INV.RT() function, and the F.INV() function was added to increase the accuracy of the results.

To ensure the backward compatibility of F.INV.RT(), the FINV() function is still available.

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

Definition. The F.INV.RT() function returns the inverse of the right F-distribution. If p = F.DIST.RT(x,...) then F.INV.RT(p,...) = x.

The F-distribution can be used in an f-test to compare the variances in two data sets. For example, you can analyze income distributions in the United States and Canada to determine whether the two countries have similar income diversity.


  • probability (required). The probability associated ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.