Syntax
=FISHER(x)Arguments
| Argument | Required | Description |
|---|---|---|
x | Required | The value, greater than -1 and less than 1 |
How to use FISHER
FISHER takes 1 required argument. Type =FISHER( 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.
=FISHER(0.75)Result Related statistical functions
- 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.
- F.TESTReturns the two tailed probability of an F test that two samples have the same variance.
- 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.
- FORECAST.ETS.SEASONALITYReturns the length of the repeating pattern detected in a time series (1 when there is none).