FTEST
TheFTEST
function returns the result of an Ftest, 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.
 How to use
FTEST
formula?  Examples of using
FTEST
formula FTEST
formula not working? Similar formulas to
FTEST
Usage
Use the FTEST
formula with the syntax shown below, it has 2 required parameters:
 range1 (required):
The first range of data to compare.  range2 (required):
The second range of data to compare.
Examples
Here are a few example use cases that explain how to use theFTEST
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. Doublecheck that you have provided the correct number of arguments.
Nonnumeric input
FTEST requires both input ranges to contain only numeric values. If one or both of the ranges contain nonnumeric 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.
Related Formulas
The following functions are similar to FTEST
or are often used with it in a formula:

TTEST
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 ttest, which can be used to determine if the null hypothesis should be rejected or not. 
ZTEST
The ZTEST function in Google Sheets returns the onetailed probabilityvalue of a ztest. 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. 
STDEV
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.