Returns the inverse of the Fisher transformation for a specified value.
Söz dizimi
FISHERINV(y)Bağımsız değişkenler
yzorunlu
The value that you want to inverse.
The Fisher transformation is used to normalize the distribution of the correlation coefficient. This function reverses that transformation, allowing you to convert a transformed value back into a correlation coefficient.
=FISHERINV(0.5)→0.462117Calculates the inverse Fisher transformation for the value 0.5.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =FISHERINV(y) and replace y with the value or cell reference you wish to transform.
It is primarily used to perform hypothesis testing on correlation coefficients by transforming them into a normally distributed variable.