 # How To Use FTEST()

Description

Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance.

Common questions about the FTEST formula:
- What is the FTEST formula?
- What does the FTEST formula do?
- What are the parameters for the FTEST formula?

How can the FTEST formula be used appropriately?
The FTEST formula can be used to compare two samples to determine if the distributions of the two populations are significantly different. It can also be used to compare the variances of two populations to determine if the populations have equal variance.

How can the FTEST formula be commonly mistyped?
The FTEST formula can commonly be mistyped as "FTESTS" or "FTESTING".

What are some common ways the FTEST formula is used inappropriately?
The FTEST formula is not appropriate for comparing data sets of different sizes or for making conditional statements (e.g., "if x, then y").

What are some common pitfalls when using the FTEST formula?
Some common pitfalls when using the FTEST formula include not checking for the assumptions of normality, not making sure the two samples being compared have an equal number of observations, and not verifying the test's assumptions (e.g., independence, homoscedasticity).

What are common mistakes when using the FTEST Formula?
Common mistakes when using the FTEST formula include not checking for the assumptions of normality and not making sure the two samples being compared have an equal number of observations.

What are common misconceptions people might have with the FTEST Formula?
Common misconceptions people might have with the FTEST Formula include that it is used to compare means of two populations, that it is used to compare individual values rather than the distributions of the two populations, that it can be used to make conditional statements, and that it can be used with data sets of different sizes.

How To Actually Use FTEST() in Sheets

`FTEST(range1, range2)`

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

Excel - F-Distribution and F-Test

ISM Course Excel Part 03.19

Better Sheets