Returns the Fisher transformation for a specified value.
構文
FISHER(x)引数
x必須
The numeric value that you want to transform, where -1 < x < 1.
The Fisher transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.
=FISHER(0.5)→0.549306Calculates the Fisher transformation for the correlation coefficient 0.5.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =FISHER(x) and replace x with a number between -1 and 1.
Press Enter
Press Enter to calculate the transformed value.
The value of x must be greater than -1 and less than 1.