SQL Server FISHERINV Function

Updated 2024-03-07 21:57:55.610000

Description

Use the scalar function FISHERINV to calculate the inverse of the Fisher transformation. The equation for the inverse of the Fisher transformation:

y=\frac{e^{2x}-1}{e^{2x}+1}=\operatorname{tanh}(x)

Syntax

SELECT [westclintech].[wct].[FISHERINV] (
   <@Y, float,>)

Arguments

@Y

is the value for which you want perform the inverse of the transformation. @Y is an expression of type float or of a type that can be implicitly converted to float.

Return Type

float

Remarks

FISHERINV(@Y) = TANH(@Y)

Examples

select wct.FISHERINV(0.972955074527657);

This produces the following result.

select wct.TANH(0.972955074527657);

This produces the following result.