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)
Argument |
Description |
Permitted values |
|---|---|---|
x |
Ratio of variances |
Any real non-negative number ≥0 or a reference to a cell containing a number |
deg_freedom1 |
Number of degrees of freedom for the variance in the numerator |
Positive real number or a reference to a cell containing a number |
deg_freedom2 |
Number of degrees of freedom for the variance in the denominator |
Positive 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.