Documentation/Calc Functions/FTEST

Function name:
FTEST

Category:
Statistical Analysis

Summary:
Calculates the two-tailed probability that indicates that variances of the given data sets are not much different.

Syntax:
FTEST(Data1; Data2)

Returns:
Returns a real number which is the result of an F test.

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 reference to a cell contains text, logical values, or empty cells, then the function ignores these values.
 * If Data1 or Data2 has a variance 0 or if the number of data points on either of them are less than 2, the function returns an error value.

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

Related LibreOffice functions:
[[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]

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

ODF standard:
None

Equivalent Excel functions:
FTEST