Syntax
=F.TEST(array1, array2)Arguments
| Argument | Required | Description |
|---|---|---|
array1 | Required | The first sample |
array2 | Required | The second sample |
How to use F.TEST
F.TEST takes 2 required arguments. Type =F.TEST( 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.
=F.TEST({6,7,9,15,21}, {20,28,31,38,40})Result Related statistical functions
- F.DISTReturns the left tailed F probability distribution.
- F.DIST.RTReturns the right tailed F probability distribution.
- F.INVReturns the inverse of the left tailed F distribution.
- F.INV.RTReturns the inverse of the right tailed F distribution.
- FISHERReturns the Fisher transformation of a value between -1 and 1.
- FISHERINVReturns the inverse of the Fisher transformation.
- FORECASTPredicts a value for x from the straight line that best fits known x and y values.
- FORECAST.ETSPredicts a future value with additive exponential triple smoothing (level, trend and season).
- FORECAST.ETS.CONFINTReturns the half width of the confidence interval around a FORECAST.ETS prediction.