Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > FISHER
 

FISHER(x)

 
 Returns the Fisher transformation at x.

 xThe numeric value for which you want the transformation.

 REMARKS
 
  		• This function returns the approximately normally distributed rather than skewed ??
     
  		• If "x" <= -1, then #NUM! is returned.
     
  		• If "x" >= 1, then #NUM! is returned.
     
  		• If "x" is not numeric, then #VALUE! is returned.
     
  		• This function can be used to perform hypothesis testing on the correlation coefficient.

     EXAMPLES
     
     A
    1=FISHER(0.75) = 0.973
    2=FISHER(0.58) = 0.662
    3=FISHER(1) = #NUM!
    4=FISHER(-1) = #NUM!
    5=FISHER("some text") = #VALUE!
    		 
     Functions - F | Index - F | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top