Definition. This function returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data.
If y = FISHER(x), then FISHERINV(y) = x.
Arguments
y (required). The value for which you want to invert the transformation
Background. The FISHERINV() function is the inverse function of FISHER(). This means that this function returns the inverse of the Fisher transformation.
FISHERINV() calculates the initial x-value of the Fisher-transformed z-value. Use this transformation when analyzing correlations between ranges or arrays of data. The equation for the inverse of the Fisher transformation is:
Example. You will find more information about the functionality of FISHERINV() in the description of FISHER().
Sample Files
Use the FISHER.INV worksheet in the Probability.xls or Probability.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.
3.144.35.122