Formula Functions > Functions D to G > FISHER |
This function returns the Fisher transformation for a specified value.
FISHER(value)
Provide a numeric value that is less than 1 and greater than –1 for which you want the transformation.
This transformation produces an approximately normal distribution. Use this function to perform hypothesis testing on the correlation coefficient.
The Fisher transformation is calculated as follows:
where x is the value argument.
Accepts numeric data. Returns numeric data.
FISHER(A43)
FISHER(R4C12)
FISHER(-0.65) gives the result -0.7752987062
This function is available in product version 1.0 or later.
FISHERINV | Statistical Functions