# Documentation/Calc Functions/F.TEST

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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

## Examples:

Data1 | Data2 | |
---|---|---|

1 | 195 | 200 |

2 | 151 | 180 |

3 | 148 | 178 |

4 | 189 | 165 |

5 | 183 | 192 |

6 | 154 | 144 |

Formula | Description | Returns |
---|---|---|

=F.TEST(A1:A6;B1:B4) | The function calculates whether the two data sets are different in their variance and returns the probability that both sets could have come from the same total population. Here the function gives the F-test result for datasets in A1:A6 and B1:B4. | 0.559085631948065 |

## Related LibreOffice functions:

## ODF standard:

None

## Equivalent Excel functions:

F.TEST