Table of Contents
This guide provides a practical overview of F. TEST Function, including its main features, benefits, limitations, and important considerations.
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!
FAQ
What does the F. TEST Function function do in Excel?
The F. TEST Function function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the F. TEST Function function correctly?
Start with an equals sign, enter F. TEST Function, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the F. TEST Function function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Reader Comments 0
Sign in with email or Google to join the discussion.