FTEST
Formulas / FTESTDetermine 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?
What is an F-test?
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?
