Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.
Syntax
FISHERINV(y)
Y is the value for which you want to perform the inverse of the transformation.
Remarks
-
If y is nonnumeric, FISHERINV returns the #VALUE! error value.
-
The equation for the inverse of the Fisher transformation is:
Example
Formula | Description (Result) |
=FISHERINV(0.972955) | Inverse of the Fisher transformation at 0.972955 (0.75) |
Coming across your webpage has been one of my highlights this January. This is what quality content looks like. The style, language and delivery meets every ECFMG CERTIFICATION REQUIREMENTS
ReplyDeleteI gotta make sure to bookmark this link and check out more of your content. Not everyday you learn HOW TO BECOME ECFMG CERTIFIED , so this was very timely. Keep up the good work dear.