Excel F.TEST Function
The F.TEST function returns the result of an F.TEST for two given arrays or ranges, which is the two-tailed probability that the variances in the two supplied arrays are not significantly different.
Syntax
=F.TEST(array1, array2)
Arguments
- array1 (required): The first range of data.
- array2 (required): The second range of data.
Return Value
The F.TEST function returns a numeric value.
Function Notes
- array1 and array2 must be numbers, or names, arrays or references that contain numbers.
- If array1 or array2 contains text(s) or logical values or empty cells, F.TEST function will ignore them.
- F.TEST returns the #DIV/0! error value if:
- The number of data points in array1 or array2 is less than 2.
- The variance of array1 or array2 is 0 (zero).
- The F.TEST value returned by the LINEST function differs from the F-test value returned by F.TEST. LINEST returns the F-statistic, whereas F.TEST returns the probability.
Example
To calculate the result of an F-test for two arrays as shown in the table below, please copy or enter the below formula in the result cell (E6), and press Enter to get the result.
=F.TEST(B6:B12,C6:C12)
Related functions
The T.TEST function returns the probability that is associated with a Student's t-test. T.TEST is often used to test the probability of two samples that have underlying populations with the same mean.
The Excel F.INV function returns the inverse of F probability distribution. If p (probability) = F.DIST(x,…), then F.INV(p,…)= x.
The Excel F.DIST function returns the F probability distribution which is usually used to measure the degree of diversity between two data sets.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.