Description Computes the inverse of the complementary F-distribution (that is, the inverse of the FDIST function.) It is used when comparing data from two different populations.
Syntax FINV(probability, df1, df2)
| Argument | Description |
|---|---|
| probability | The probability, as obtained from the FDIST function. It must be a number between 0 and 1 that represents a probability. |
| df1 | A positive integer indicating degrees of freedom in the numerator. Decimal values will be rounded down to the nearest integer. |
| df2 | A positive integer indicating degrees of freedom in the denominator. Decimal values will be rounded down to the nearest integer. |
Remarks This function can be used to compute the critical value needed to test the "null hypothesis" in many statistical experiments. For example, if there is to be less than a 1% chance that results are due to random effects for two populations, you can run FINV with 0.01 as the probability argument and the number of degrees of freedom you choose. Values achieved in the experiment must be higher than the resultant critical value in order to be significant.
Examples This function returns 7.71:
This function returns 9.01:
See Also FDIST, FTEST, TDIST, TINV, TTEST
