How to use the F.DIST.RT function
What is the F.DIST.RT function?
The F.DIST.RT function calculates the right-tailed F probability for two tests. This function was introduced in Excel 2010 and has replaced the FDIST function.
What are the differences between the F.DIST function and the F.DIST.RT function?
The F.DIST function gives the left-tail area under the curve, while the F.DIST.RT function gives the right-tail area under the curve.
The F.DIST function calculates the cumulative distribution function for the F-distribution, which means it returns the probability that a random variable with an F-distribution is less than or equal to the input F-value.
The F.DIST.RT function calculates the right-tailed probability of the F-distribution, which means it returns the probability that a random variable with an F-distribution is greater than the input F-value.
F.DIST.RT(x, deg_freedom1, deg_freedom2)
F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
What is the F probability?
The F-distribution or F-ratio is a continuous probability distribution that compare the variances of two populations.
What is variance?
The variance shows how much a set of numbers are spread out from their average value.
Σ(x- x̄)2/(n-1)
x̄ is the sample mean
n is the sample size.
What is a null distribution?
The null hypothesis in the F-distribution is that two independent normal variances are equal. If the observed ratio is too large or too small, then the null hypothesis is rejected, and we conclude that the variances are not equal.
When is a f-distribution used?
The F-distribution is used in the F-test in analysis of variance comparing two variances, as the distribution of the ratio of sample variances when the null is true of no difference between population variances.
What is a continuous probability distribution?
A continuous probability distribution is defined over an interval and range of continuous values, giving the probability an outcome is exactly equal to any value, and having an area under its probability density curve equal to 1.
F.DIST.RT Function Syntax
F.DIST.RT(x, deg_freedom1, deg_freedom2)
F.DIST.RT Function Arguments
| x | Required. |
| deg_freedom1 | Required. Degrees of freedom (numerator). |
| deg_freedom2 | Required. Degrees of freedom (denominator). |
What are the degrees of freedom?
The degrees of freedom parameters are the numerator and denominator chi-squared distributions. They form the ratio that follows the F-distribution.
The degrees of freedom parameters affect the shape of the F-distribution curve and probability, they relate to the samples and capture the amount of information in the variance estimates.
What is a chi-squared distribution?
A chi-squared distribution is a type of probability distribution that is used in statistical tests that compare the variances of two populations. The chi-squared distribution has one parameter, called degrees of freedom, that determines its shape and location. The degrees of freedom represent the number of independent pieces of information used to estimate the variances.
F.DIST.RT function example
Formula in cell C7:
=F.DIST.RT(C3,C4,C5)
F.DIST.RT function not working
The F.DIST.RT function returns
- #VALUE! error value if any argument is non-numeric.
- #NUM! error value if:
- x < 0 (zero)
- deg_freedom1 < 1
- deg_freedom2 < 1
deg_freedom1 and deg_freedom2 will be converted into integers if they are not.
Functions in 'Statistical' category
The F.DIST.RT function is one of many functions in the 'Statistical' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form