F.INV.RT()/FINV()

Note

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.

Arguments

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

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.