Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11F.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.
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:
- In the cell to calculate enter the formula : = F.TEST (B6: B10, C6: C10)
- Press Enter -> check F - test for the data sets in the 2 above arrays are:
- Where the value of the data array is a logical value or text -> the function ignores that value.
Above are instructions and some specific examples when using the F.TEST function in Excel.
Good luck!
Samuel DanielYou should read it
- 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
- BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel
- ZTEST function - Returns the probability value on one side of the z test in Excel
- TTEST - Returns the probability associated with a Student's t-Test in Excel
- FISHER function - The function returns the Fissher transformation at x in Excel
- CHITEST function - The function returns the independence test in Excel
- How to implement T-Test in Excel
May be interested
- How to use the IF function in Excel
the if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value - GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excelquartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
- PHI function - The function returns the value of the density function for a normal distribution in Excelphi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
- FORECAST function - The function returns a value along a linear trend in Excelforecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- How to use the IFS function in Excel 2016the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excelgamma.inv: the function returns the inverse of the gamma distribution, using this function to study their distribution variables that may be symmetrical. support functions from excel 2010 onwards. syntax: gamma.inv (probability, alpha, beta)
Office information
- FISHER function - The function returns the Fissher transformation at x in Excel
- FISHERINV function - Function that returns the inverse of the Fissher transformation in Excel
- FORECAST function - The function returns a value along a linear trend in Excel
- FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excel
- GAMMA function - The function returns the gamma function value in Excel
- GAMMA.DIST function - The function returns the gamma distribution in Excel
FISHER function - The function returns the Fissher transformation at x in Excel
FISHERINV function - Function that returns the inverse of the Fissher transformation in Excel
FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excel
GAMMA.DIST function - The function returns the gamma distribution in Excel