Menu
EXCEL F.TEST FUNCTION
Excel F.TEST Function Introduction
The F.TEST function in Excel returns the F-Test for two arrays. In other words, the function returns the two-tailed probability that the variances in the two provided arrays do not differ considerably.
Description of Excel F.TEST Function
Syntax :
=F.TEST( array1, array2 )
Parameters :
- array1 and array2 are two data value arrays that represent samples from two separate populations. Text, logical values, and empty cells in the arrays are disregarded.
Step By Step Guide of F.DIST Function
Example :
The response times of a sample of individuals from two separate groups are shown in columns A and B of the spreadsheet on the right. The spreadsheet’s Cell C2 illustrates the usage of the Excel F.Test function to compute the likelihood that there is no significant difference between the variances of the two data sets.
The result of the F.Test function in cell C2 is 0.954035559.
Key Points
- #DIV/0! – Occurs when either: the number of values in array1 or array2 is less than 2 or
The variance of arrays 1 and 2 is equal to zero.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
