Returns the inverse of the Fisher transformation for a given number and creates a function close to a normal distribution.
Returns a real number which is the inverse of Fisher transformation value Number. The output ranges from -1(exclusive) to +1(exclusive), i.e. (-1,+1).
Number is a real number or a reference to the cell containing that number which is the value that is to undergo inverse transformation.
- The formula for FISHERINV function is:
where x is the Number.
- The figure below illustrates the FISHERINV function:
- The function has the same formula as the TANH function.
- It is such that FISHERINV(FISHER(x)) = x.
|=FISHERINV(0.8)||The formula calculates the inverse Fisher transformation of 0.8.||0.664036770267849|
|=FISHERINV(1.8)||The formula calculates the inverse Fisher transformation of 1.8.||0.946806012846268|
Related LibreOffice functions:
Equivalent Excel functions: