FISHER(x)

Returns the fisher transformation.

xThe numeric value for which you want the transformation.

Remarks

* This function returns the approximately normally distributed rather than skewed ??
* If "x" <= -1, then #NUM! is returned.
* If "x" >= 1, then #NUM! is returned.
* If "x" is not numeric, then #VALUE! is returned.
* This function can be used to perform hypothesis testing on the correlation coefficient.
* You can use the FISHERINV function to return the inverse fisher transformation.
* For the Microsoft documentation refer to support.office.com

 A
1=FISHER(0.75) = 0.973
2=FISHER(0.58) = 0.662
3=FISHER(1) = #NUM!
4=FISHER(-1) = #NUM!
5=FISHER("some text") = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top