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

FISHERINV(y)

 
 Returns the inverse of the Fisher transformation.

 yThe number you want the inverse of the Fisher transformation of.

 REMARKS
 
  		• The inverse of the Fisher Transformation is the inverse of the FISHER() function.
     
  		• Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.
     
  		• If "y" is not numeric, then #VALUE! is returned.

     EXAMPLES
     
     A
    1=FISHERINV(0.972955) = 0.75
    2=FISHERINV(0.66) = 0.578
    3=FISHERINV(FISHER(0.75)) = 0.75
    4=FISHERINV("0.66") = 0.578
    5=FISHERINV("some text") = #VALUE!
    		 
     Functions - F | Index - F | Office Online 

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