# Manuals/calci/FTEST

Jump to navigation
Jump to search

**FTEST(Array1,Array2)**

- and are array of data.
- FTEST(), returns the result of an F-test.

## Description

- This function gives the result of F-test.
- The F-test is designed to test if two population variances are equal.
- It does this by comparing the ratio of two variances.
- So, if the variances are equal, the ratio of the variances will be 1.
- Let X1,...Xn and Y1,...Ym be independent samples each have a Normal Distribution .
- It's sample means:

and

- .

- The sample variances :

and

- Then the Test Statistic = has an F-distribution with 'n−1' and 'm−1' degrees of freedom.
- In FTEST(Array1,Array2) where is the data of first array, is the data of second array.
- The array may be any numbers, names, or references that contains numbers.
- values are not considered if the array contains any text, logical values or empty cells.

When the or is less than 2 or the variance of the array value is zero, then this function will return the result as error.

## ZOS

- The syntax is to calculate FTEST in ZOS is .
- and are array of data.

- For e.g.,FTEST([15,29,30],[62,74,80])

## Examples

1.

15 | 27 | 19 | 32 |

21 | 12 | 30 | 11 |

=FTEST(B4:B8,C4:C8)=0.81524906747183

2.

5 | 8 | 12 | 45 | 23 |

10 | 20 | 30 | 40 | 50 |

=FTEST(A1:A5,C1:C5)=0.9583035732212274

3.

14 | 26 | 37 |

45 | 82 | 21 | 17 |

FTEST(B1:B3,C1:C4} = 0.26412211240525474

4.

14 |

45 | 65 |

=FTEST(B1,C2:C3)=NAN

## Related Videos

## See Also

## References