FISHERINV()

Syntax. FISHERINV(y)

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

Note

If y isn’t a numeric value, the FISHERINV() function returns the #VALUE! error.

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:

See Also

You will find more information about Fisher transformations in the description of FISHER().

Example. You will find more information about the functionality of FISHERINV() in the description of FISHER().

See Also

CORREL(), COVAR(), 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.