Check Sheet Logo
Check Sheet


The FTEST function returns the result of an F-test, which tests whether two data sets have different variances. The function takes two ranges of data as inputs and returns a probability value, which can be used to determine the likelihood that the variances of the two data sets are equal.


Use the FTEST formula with the syntax shown below, it has 2 required parameters:

=FTEST(range1, range2)
  1. range1 (required):
    The first range of data to compare.
  2. range2 (required):
    The second range of data to compare.


Here are a few example use cases that explain how to use the FTEST formula in Google Sheets.

Comparing variances of two data sets

Use FTEST to determine the likelihood that two data sets have different variances. This can be useful in statistical analysis, such as when testing the effectiveness of different treatments or interventions.

Quality control in manufacturing

In manufacturing, FTEST can be used to compare the variability of two production processes. If the variances are significantly different, this may indicate a problem with the manufacturing process that needs to be addressed.

Analyzing survey data

When analyzing survey data, FTEST can be used to compare the variances of responses to different questions. This can help identify which questions have more variability in responses, which may indicate areas where further investigation is needed.

Common Mistakes

FTEST not working? Here are some common mistakes people make when using the FTEST Google Sheets Formula:

Incorrect range reference

One of the most common mistakes when using FTEST is referencing the wrong range in the function's arguments. Make sure the ranges you provide as input are correct and properly formatted.

Missing arguments

Another common mistake is forgetting to include one or both of the required arguments for the FTEST function. Double-check that you have provided the correct number of arguments.

Non-numeric input

FTEST requires both input ranges to contain only numeric values. If one or both of the ranges contain non-numeric data, FTEST will return an error. Check that your input ranges contain only numeric data.

Mismatched range sizes

FTEST requires both input ranges to be the same size. If the ranges have different numbers of cells, FTEST will return an error. Make sure both ranges have the same number of cells.

Incorrect use of function

FTEST is used to compare the variances of two datasets. It is not appropriate for other types of statistical analysis. Make sure you are using FTEST correctly for your intended purpose.

The following functions are similar to FTEST or are often used with it in a formula:


    The TTEST formula is a statistical formula used to determine the probability of two sample means being equal. It is commonly used in hypothesis testing to determine if there is a significant difference between two sets of data. The formula returns the probability value associated with a t-test, which can be used to determine if the null hypothesis should be rejected or not.


    The ZTEST function in Google Sheets returns the one-tailed probability-value of a z-test. It is used to determine whether a sample mean is significantly different from a hypothesized value, assuming a known population standard deviation. This function is typically used in hypothesis testing and statistical analysis.

  • VAR

    The VAR formula calculates the variance of a set of numerical values. Variance is a measure of how spread out a set of data is in relation to the mean. This formula is commonly used in statistical analysis to measure the variability or diversity of a dataset.


    The STDEV function calculates the standard deviation of a set of numbers. It measures the amount of variation or dispersion of a set of values from the average (mean) value. It is commonly used in statistics to determine the spread of a data set. The values can be supplied as individual cells, ranges, or constants.

Learn More

You can learn more about the FTEST Google Sheets function on Google Support.