How to use the F.DIST function
What is the F.DIST function?
The F.DIST function calculates the F probability for two tests. This function was introduced in Excel 2010 and has replaced the FDIST function.
The F.DIST function lets you find out if the means between two given populations are significantly different.
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 function Syntax
F.DIST(x, deg_freedom1, deg_freedom2, cumulative)
F.DIST function Arguments
x | Required. |
deg_freedom1 | Required. Degrees of freedom (numerator). |
deg_freedom2 | Required. Degrees of freedom (denominator). |
cumulative | Required. A boolean value. TRUE - Cumulative distribution function. FALSE - Probability density function. |
F.DIST function example
Formula in cell C7:
F.DIST function not working
The F.DIST 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 function function is one of 74 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