The ATANH() function returns the inverse hyperbolic tangent of a given value. It calculates the value whose hyperbolic tangent equals the input, mathematically expressed as 0.5 × ln((1 + x) / (1 - x)). The function accepts values between -1 and 1 (exclusive) and returns any real number. It's the inverse operation of the hyperbolic tangent function.
This function can be useful for converting normalized correlation coefficients between two rolling averages into unbounded scores for deeper trend comparisons.
Syntax
ATANH(Value)
Arguments
| Argument | Data type | Description |
| Value | Number | The numeric value for which you want to calculate the inverse hyperbolic tangent. The input must be between -1 and 1, exclusive of -1 and 1. |
The ATANH() function returns a numeric value.
Calculation engine functionality differences
This function is only available in the Polaris Calculation Engine.
Syntax example
ATANH(0.5)
Additional information
Returns NaN when Angle is NaN.
Excel equivalent
Examples
| Formula | Result |
ATANH(0.76159416) | 1 |
ATANH(-0.1) | -0.1003 |
Example 1: Customer satisfaction score sensitivity mapping
Example 2: Currency hedging effectiveness ratio transformation
Example 3: Warehouse order fulfillment accuracy transformation
Example 4: Internal promotion rate health scoring across divisions
