In Google Sheets, the function F.INV(probability, degreesfreedom1, degreesfreedom2) returns the inverse of the F-distribution.

It calculates the value x for which the cumulative distribution function (F.DIST) is equal to the specified probability.

Here's a breakdown of the function's arguments:

Probability: This is the probability at which you want to evaluate the inverse F-distribution. It must be between 0 and 1 (inclusive).

Degrees_freedom1: This represents the degrees of freedom for the numerator of the F-distribution.

Degrees_freedom2: This represents the degrees of freedom for the denominator of the F-distribution.

The F-distribution is commonly used in statistics to analyze the variability between two sets of data.

The F.INV function allows you to determine a critical value for a given probability, which can be helpful in hypothesis testing or constructing confidence intervals.

To use the F.INV function in Google Sheets, you can enter it in a cell as follows:

=F.INV(probability, degreesfreedom1, degreesfreedom2)

Replace "probability," "degreesfreedom1," and "degreesfreedom2" with the specific values or cell references you want to use in your calculation.