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.
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!
You should read it
- BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel
- Z.TEST function - The function returns one-sided value of the z test in Excel
- T.TEST function - The function returns the probability associated with Student's t-Test in Excel
- ZTEST function - Returns the probability value on one side of the z test in Excel
- FISHER function - The function returns the Fissher transformation at x in Excel
- How to use the IF function in Excel
- How to use the IFS function in Excel 2016
- OR function in Excel, how to use the OR function, and examples
May be interested
- PV function - Function that gives the current value of the investor in Excelthe following article contains detailed instructions for the pv function to help you determine the current value of the investor.
- COUPNUM function - The function returns the number of interest payments on a security in Excelin the process of investing in securities, paying special interest is very important. it helps you calculate and plan a reasonable calculation and investment. the following article details the coupnum function - the function returns the number of interest payments of securities in excel.
- DURATION function - The function returns the periodic periodic interest payments in Excelthe following article details how to use the duration function to determine the period of periodic interest payment.
- EFFECT function - The function of calculating the annual real interest rate in Excelthe following article details how to use the effect function - the annual real interest rate calculation function which is very helpful for accountants and offices.
- NORMDIST function - The function returns the normal distribution with the standard deviation and the average value specified in Excelthe following article details the normdist function - the function returns the normal distribution in excel.
- NORMSDIST function - The function returns the normal cumulative distribution in Excelthe following article details how to use the normsdist function - the function returns the cumulative normal distribution in excel.