How to Use the FTEST Function in Excel

This guide explains how to use FTEST Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function that returns the result of an F-test or is the probability of two ends where the difference or the variance in the data arrays is not significant. Functional application of testing two data samples to see how their variances differ.

Syntax: FTEST (array1, array2) .

Inside:

- array 1 : The first array of data range to check, is a required parameter.

- array 2 : The second array of data range to check, is a required parameter.

Attention:

- The parameters must be either numbers or names, arrays or references must contain numeric values.

- If one of the two parameters contains a logical value or a blank text, the function will ignore that value.

- The number of points in the 2 parameters must be greater than or equal to 2 and the variance of the 2 parameters must be different from zero, otherwise the function returns the # DIV / 0 error value.

- Pay attention to distinguish two F-test values of LINEST function and FTEST function, F- test of LINEST function used in F statistics, and F-test function FTEST returns a probability value.

For example:

Give the following data sheet. Calculate the value of F-test.

In the cell to be calculated enter the following formula: = FTEST (D6: I6, D7: I7).

Note the value of the result cell you should put in decimal format with at least 2 decimal places. Because the value is usually less than 1 if you format the integer, the result returns 0. The result is calculated as:

So the probability of the difference between the two data arrays is 0.330673.

Above is how to use FTEST function, wish you success!