F.TEST
TheF.TEST
function returns the result of an Ftest, which tests the equality of variances between two datasets. It is commonly used to compare the variances of two datasets to determine if they are significantly different. If the result is less than or equal to a critical value, the variances are considered equal. If the result is greater than the critical value, the variances are considered unequal.
 How to use
F.TEST
formula?  Examples of using
F.TEST
formula F.TEST
formula not working? Similar formulas to
F.TEST
Usage
Use the F.TEST
formula with the syntax shown below, it has 2 required parameters:
 range1 (required):
The first range or array of values to test variance equality.  range2 (required):
The second range or array of values to test variance equality.
Examples
Here are a few example use cases that explain how to use theF.TEST
formula in Google Sheets.
Comparing variances of two datasets
Suppose you want to compare the variances of two datasets to determine if they are significantly different. You can use the F.TEST
function to perform an Ftest on the two datasets and get a result. If the result is less than or equal to a critical value, the variances are considered equal. If the result is greater than the critical value, the variances are considered unequal.
Testing for homoscedasticity
Homoscedasticity refers to the assumption that the variances of the errors are constant across all levels of the independent variable. You can use the F.TEST
function to test for homoscedasticity by comparing the variances of the residuals of a regression model at different levels of the independent variable.
Testing for equality of variances in ANOVA
In ANOVA, it is important to test for the equality of variances between the groups before performing the test. You can use the F.TEST
function to test for the equality of variances between the groups and determine if the assumption of equal variances is met.
Common Mistakes
F.TEST
not working? Here are some common mistakes people make when using the F.TEST
Google Sheets Formula:
Incorrect range format
One common mistake users make is not providing the correct range format for the formula. This can cause errors or unexpected results. Make sure the ranges provided are in the correct format, such as A1:B10.
Nonnumeric data
F.TEST only works with numeric data. If there is nonnumeric data in either range, the formula will result in an error. Make sure both ranges contain only numeric data.
Empty cells in range
If there are empty cells within the ranges provided, this can cause unexpected results or errors with the formula. Make sure there are no empty cells within the ranges provided.
Mismatched ranges
Both ranges must have the same number of data points, otherwise the formula will result in an error. Make sure both ranges have the same number of data points.
Incorrect use of F.TEST
F.TEST is a statistical formula that tests the hypothesis that two datasets have the same variance. Make sure you understand the purpose of F.TEST and how to interpret the results before using it.
Related Formulas
The following functions are similar to F.TEST
or are often used with it in a formula:

VAR.P
The
VAR.P
function returns the variance of its arguments, which is a measure of the spread of a dataset in statistics. Unlike theVAR
function,VAR.P
function considers all the values in the dataset when calculating its variance, not just a sample of them. The function is commonly used to analyze the variability of a dataset and determine how much the data points deviate from the mean. 
VAR.S
The
VAR.S
function is a statistical function that calculates the variance of a sample of data. Variance is a measure of how spread out a set of data is from the average value. It is commonly used to analyze data and make decisions based on how much variation there is in the data. 
STDEV.P
The
STDEV.P
function is a statistical function that calculates the standard deviation of a population based on a sample of numerical data. It is commonly used to measure the amount of variation or dispersion in a dataset. The formula assumes that the input values represent the entire population, rather than a sample. If the input values represent a sample, you should use theSTDEV.S
function instead. 
STDEV.S
The
STDEV.S
formula calculates the standard deviation of a sample of data. It is commonly used to measure the amount of variation or dispersion of a set of values from their average. This formula accepts up to 255 arguments, which can be numbers, arrays, or references that contain numbers. The result is a measure of how spread out the data is, with a larger standard deviation indicating greater variability. 
T.TEST
The
T.TEST
function calculates the probability associated with a Student's ttest. This function is commonly used in statistics to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. It returns the probability that the two samples are different. The function assumes that the two samples are independent of each other and have equal variances.
Learn More
You can learn more about the F.TEST
Google Sheets function on Google Support.