# F.TEST

Formulas / F.TEST
Determine if two samples have the same variances.
`FTEST(array1,array2)`
• array1 - required, the first array or range of data
• array2 - required, the second array or range of data

## Examples

Using the F.TEST function, we can determine whether the public and private schools have different levels of test score diversity. This is done by passing the F.TEST function two parameters: the range of scores from the public schools, and the range of scores from the private schools. The F.TEST function will then calculate the difference between the two ranges and output a value that can be used to determine if the two sets of scores are significantly different or not.

Using the F.TEST function, we can also compare the scores of different groups within the same school. For example, if we wanted to compare the scores of male and female students at a particular school, we could pass the F.TEST function two parameters: the range of scores for male students, and the range of scores for female students. The F.TEST function will then calculate the difference between the two ranges and output a value that can be used to determine if the two sets of scores are significantly different or not.

The F.TEST function can also be used to compare test scores across multiple schools. For example, if we wanted to compare the scores of two different schools, we could pass the F.TEST function two parameters: the range of scores from school A, and the range of scores from school B. The F.TEST function will then calculate the difference between the two ranges and output a value that can be used to determine if the two sets of scores are significantly different or not.

## Summary

The F.TEST function is a statistical test that measures the probability that two samples have similar variances. It is useful for determining if samples have different variances.

• The F.TEST function returns a two-tailed probability that indicates whether two samples have similar variances.
• The F.TEST function can only be used on data sets with two numerical arguments.