Skip to main content

F.DIST.RT

The F.DIST.RT function returns the right-tailed F distribution for two data sets.

Allows to determine the probability that the difference between variances occurred randomly.

This function is used in the F test to compare the variances of two samples, and is often used in variance analysis, regression analysis, and statistical hypothesis testing.

Syntax​

F.DIST.RT(x, deg_freedom1, deg_freedom2)

ArgumentDescriptionPermitted values
xRatio of variancesAny real non-negative number ≥0 or a reference to a cell containing a number
deg_freedom1Number of degrees of freedom for the variance in the numeratorPositive real number or a reference to a cell containing a number
deg_freedom2Number of degrees of freedom for the variance in the denominatorPositive real number or a reference to a cell containing a number

Examples of use​

Calculating the probability for the F-distribution

=F.DIST.RT(2.5, 4, 8)

This formula calculates the right-tailed probability for an F distribution with a value of 2.5, 4 degrees of freedom in the numerator, and 8 degrees of freedom in the denominator.

Result: approximately 0.115.

Use in dispersion analysis

=F.DIST.RT(3.24, 3, 20)

The function will return the right-tailed probability for 3 degrees of freedom in the numerator and 20 in the denominator.

Testing a statistical hypothesis

=IF(F.DIST.RT(A1, B1, C1)<0.05, "Reject H0", "Accept H0")

This formula tests the statistical hypothesis: if the probability is less than 0.05, the null hypothesis is rejected.

Notes​

  • The values of the arguments for degrees of freedom (deg_freedom1 and deg_freedom2) are rounded to integers if they are fractional.
  • The values of the arguments for degrees of freedom (deg_freedom1 and deg_freedom2) must be greater than 1 and cannot exceed 10 to the power of 10.