The FTEST function is a type of computational compatibility function about the F-Test in statistical probability. This is a function that allows the calculation of the difference in variance. To use the FTEST function, please refer to the article below.
The FTEST function will return the results of an F-test, a type of test that returns a two-headed probability that the variance in different arrays of data is negligible. It is often used to determine whether two data samples have different variances and, if so, how they differ.
FTEST function and examples
How to Use the FTEST Function in Excel – Illustrative Example
Syntax: FTEST(array1,array2)
Where:
– Array1 : Required – Is the first array of the data range.
– Array2 : Required – Is the second array of the data range.
Consider an example
Give the Excel spreadsheet the actual values corresponding to the parameters of the FTEST function, and in this example are two arrays of data with 10 different values as shown in the figure:
Enter the calculation in cell C8. And the result of the calculation of the function obtained is 0.617458836:
https://thuthuat.taimienphi.vn/ham-ftest-trong-excel-2248n.aspx
So you already know how to use the FTEST function in Excel. When performing parameter value entry for calculation with this function, you need to pay attention that the arguments must be numbers or names, arrays or references containing numbers to get the most accurate calculation results. The FTEST function is applied on Office