FISHERINV(y)

Returns the inverse of the fisher transformation.

yThe number you want the inverse of the Fisher transformation of.

Remarks

* Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.
* If "y" is not numeric, then #VALUE! is returned.
* You can use the FISHER function to return the fisher transformation.
* For the Microsoft documentation refer to support.office.com

 A
1=FISHERINV(0.972955) = 0.75
2=FISHERINV(0.66) = 0.578
3=FISHERINV(FISHER(0.75)) = 0.75
4=FISHERINV("0.66") = 0.578
5=FISHERINV("some text") = #VALUE!


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