# Documentation/Calc Functions/FTEST

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.

For more details on 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
=FTEST(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. Hee the function gives f-test result for datasets in A1:A6 and B2:B4 0.559085631948065

None

FTEST