FTEST function - The function returns the result of an F-Test in Excel

In statistical probability, the determination of the correctness and the deviation between two data samples is a regular and extremely important job. The following article shows in detail how to use FTEST - The function returns the results of the F-test to help you solve the above problem.

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.

FTEST function - The function returns the result of an F-Test in Excel Picture 1

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

FTEST function - The function returns the result of an F-Test in Excel Picture 2

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:

FTEST function - The function returns the result of an F-Test in Excel Picture 3

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

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