FisherINV (Function)
DisclaimerThe FisherINV function calculates the inverse of the Fisher transformation.
Syntax
FisherINV(Price)
Returns (Double)
A numeric value containing the inverse Fisher transformation for the specified number.
Parameters
|
Name |
Type |
Description |
|
Price |
Numeric |
Sets a number use to for calculating the inverse Fisher value. |
Remarks
Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.
Example
Assigns to Value1 the Fisher inverse value based on an input of .97295.
Value1 = FisherINV(.97295);