F.TEST function - The function returns the result of the F - test in Excel

The following article introduces you to the F.TEST function - one of the functions in the statistical function group is very popular in Excel.

F.TEST function - The function returns the result of the F - test in Excel Picture 1

Description: The function returns the result of the F - test, the probability of two ends where the variance of the two arrays is not significant. Support function from Excel 2010 version.

Syntax: F.TEST (array1, array2)

Inside:

- array1: The first array of data range, is the required parameter.

- array2: The second array of data range, is a required parameter.

Attention:

- The value of the parameters must be a number, name or reference array containing numbers.

- The value of the parameter contains the logical value, the text will be ignored, but a value of 0 is still counted.

- If the number of data points in 2 arrays is different -> the function returns the error value # DIV / 0!

For example:

Calculate the F - test for data sets according to the data in the following data table:

F.TEST function - The function returns the result of the F - test in Excel Picture 2

- In the cell to calculate enter the formula : = F.TEST (B6: B10, C6: C10)

F.TEST function - The function returns the result of the F - test in Excel Picture 3

- Press Enter -> check F - test for the data sets in the 2 above arrays are:

F.TEST function - The function returns the result of the F - test in Excel Picture 4

- Where the value of the data array is a logical value or text -> the function ignores that value.

F.TEST function - The function returns the result of the F - test in Excel Picture 5

Above are instructions and some specific examples when using the F.TEST function in Excel.

Good luck!