Syntax
=FTEST(array1, array2)Arguments
| Argument | Required | Description |
|---|---|---|
array1 | Required | The first sample |
array2 | Required | The second sample |
How to use FTEST
FTEST is kept so older workbooks keep working. It calculates the same way as F.TEST, which is the name to use in new formulas.
FTEST takes 2 required arguments. Type =FTEST( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=FTEST({6,7,9,15,21}, {20,28,31,38,40})Result Related compatibility functions
- CRITBINOMReturns the smallest number of successes reaching a cumulative probability (older name of BINOM.INV).
- EXPONDISTReturns the exponential distribution (older name of EXPON.DIST).
- FDISTReturns the right tailed F distribution (older name of F.DIST.RT).
- FINVReturns the inverse of the right tailed F distribution (older name of F.INV.RT).
- GAMMADISTReturns the gamma distribution (older name of GAMMA.DIST).
- GAMMAINVReturns the inverse of the gamma distribution (older name of GAMMA.INV).
- HYPGEOMDISTReturns the hypergeometric probability (older form of HYPGEOM.DIST).
- LOGINVReturns the inverse of the lognormal distribution (older name of LOGNORM.INV).
- LOGNORMDISTReturns the cumulative lognormal distribution (older form of LOGNORM.DIST).