F.TEST Function in Excel: Syntax, Examples and Free Practice
F.TEST is an Excel Statistical function. Returns the result of an F-test comparing variances.
F.TEST syntax
=F.TEST(array1, array2)
Arguments
array1: The first range or arrayarray2: The second range or array
When to use F.TEST
F.TEST is used in data analysis work to summarize or test patterns across a data set.
Practice F.TEST online, free
Open the live Excel-style spreadsheet and try F.TEST yourself. No Excel install or sign-up needed to start.
Practice F.TEST now →More Statistical functions
Frequently asked questions
What does the F.TEST function do in Excel?
Returns the result of an F-test comparing variances.
What is the syntax of F.TEST in Excel?
The syntax is =F.TEST(array1, array2). array1: The first range or array; array2: The second range or array.
Where can I practice F.TEST online for free?
Open the free live spreadsheet on Cellgrids and try F.TEST yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts