FISHER (Number)

  • is the value to find the Fisher transformation.
    • FISHER(), returns the Fisher transformation.


  • This function gives the value of Fisher Transformation for the given number.
  • Fisher Transformation is used to test the hypothesis of two correlations.
  • It is mainly associated with the Pearson Product-Moment Correlation coefficient for bi-variate normal observations.
  • In  ,   is the value which ranges between -1 to +1.
  • The transformation is defined by :  

where   is the natural logarithm function and   is the Inverse Hyperbolic function.

  • This function will give the result as error when:
1.  is non-numeric
2.  or  .


  • The syntax is to calculate FISHER in ZOS is  .
    •   is the value to find the Fisher transformation.
  • For e.g.,FISHER(0.1..0.4..0.1)
Fisher Transformation


  1. FISHER(0.5642) = 0.6389731838284958
  2. FISHER(0)= 0
  3. FISHER(-0.3278) = -0.3403614004970268
  4. FISHER(1) = Infinity
  5. FISHER(-1) = -Infinity

Related Videos

Sampling Distributions

See Also


Fisher Distribution