Documentation/Calc Functions/F.TEST

Function name:
F.TEST

Category:
Statistical Analysis

Summary:
Calculates the two-tailed probability that, based on two sets of samples from two normal distributions, these normal distributions have different variances.

Syntax:
F.TEST(Data1; Data2)

Returns:
Returns a real number which is the result of an F test. The result ranges from 0 to 1, i.e. [0,1].

Arguments:
Data1 is a reference to a range of cells that is considered the first data set.

Data2 is a reference to a range of cells which is considered the second data set.


 * If a cell contains text or empty cells, then the function ignores these values.
 * If Data1 or Data2 has a variance of 0 or if the number of data points in either of them is less than 2, the function returns an error value.

Additional details:
For more details on the F-test, visit Wikipedia

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/FTEST FTEST]

[[Special:MyLanguage/Documentation/Calc_Functions/F.DIST.RT F.DIST.RT]

[[Special:MyLanguage/Documentation/Calc_Functions/F.INV.RT F.INV.RT]

[[Special:MyLanguage/Documentation/Calc_Functions/F.INV F.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/FDIST FDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/F.DIST F.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/FINV FINV]

ODF standard:
None

Equivalent Excel functions:
F.TEST