FTEST

Formulas / FTEST
Determine whether two samples have different variances.
=FTEST(array1,array2)
  • array1 - required, first array or range of data
  • array2 - required, second array or range of data

Examples

  • =FTEST(A2:A6,B2:B6)

    The FTEST function can be used to compare two data sets. For example, if you have two sets of data in cells A2 to A6 and B2 to B6, you can use the FTEST function to compare the two. This will return the F-test for the two data sets.

  • =FTEST(A2:A6,B2:B6)

    The FTEST function is often used to compare the variances of two data sets. For example, you can use the FTEST function to compare the variance of the values in cells A2 to A6 with the variance of the values in cells B2 to B6. This will return the F-test for the two data sets, and can be used to determine if the variances are significantly different.

  • =FTEST(A2:A6,B2:B6)

    The FTEST function can be used to compare two groups of data. For example, if you have a list of sales figures for two different sales teams in cells A2 to A6 and B2 to B6, you can use the FTEST function to compare the two teams. This will return the F-test for the two groups of data, and can be used to determine if the teams have significantly different sales figures.


Summary

The FTEST function is used to compare the variances of two samples in Sourcetable. It is a backward compatible function which may be replaced by the F.TEST function for improved accuracy.

  • The F.TEST function is used to determine whether the variance in one dataset differs significantly from the variance in another dataset.
  • It requires two datasets and will not work on text, logical values, or empty cells.

Frequently Asked Questions

What is the FTEST function?
The FTEST function is a statistical function that returns the result of an F-test for a data set. It is used to determine whether two samples have significantly different variances.
What is an F-test?
An F-test is a statistical test used to compare two samples. It measures the ratio of the variances of two samples to determine if they are significantly different.
What are the benefits of using the FTEST function?
  • It is a reliable and accurate method of determining if two samples have significantly different variances.
  • It is easy to use and interpret the results.
What types of data can be used with the FTEST function?
The FTEST function can be used with any type of data, including numerical and categorical data.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV