Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

Computes the arctangent of an input value for a hyperbolic angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

A hyperbola is the shape created by taking a planar slice of two cones whose tips are touching each other. For two identical cones, the curves of the slices mirror each other, no matter the angle of the plane through the cones.

  • The two slices represent the set of points on a grid such that:

    where k is some constant.

  • The hyperbolic trigonometric functions measure trigonometric calculations for the right-side (x > 0) slice of the hyperbola.
  • For more information, see https://en.wikipedia.org/wiki/Hyperbola.

The hyperbolic arctangent (ATANH) function is computed using the following formula:

You can convert from degrees to radians. For more information, see RADIANS Function.

Basic Usage

Numeric literal example:

Output: Returns the computation of the hyperbolic angle in radians whose tangent is 0.5. The output value is rounded to two decimals: 31.47.

Column reference example:

Output: Returns the hyperbolic angle the tangent value for which is stored in radians in X column.

Syntax


ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column, Decimal or Integer literal, or function returning those types to apply to the function

For more information on syntax standards, see Language Documentation Syntax Notes.

numeric_value

Name of the column, Integer or Decimal literal, or function returning that data type to apply to the function.

  • Missing input values generate missing results.
  • Literal numeric values should not be quoted. Quoted values are treated as strings.
  • Multiple columns and wildcards are not supported.

Usage Notes:

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal0.5

Examples

Example - Hyperbolic arc trigonometry functions

This example illustrates how to apply inverse (arc) hyperbolic functions to your transformations.

Source:

In the following sample, input values are in radians. In this example, all values are rounded to two decimals for clarity.


Y
-4.00
-3.00
-2.00
-1.00
-0.75
-0.50
0.00
0.50
0.75
1.00
2.00
3.00
4.00

Transformation:

The following transformations include checks for the valid ranges for input values.

Hyperbolic arcsine:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(degrees(asinh(Y)), 2)
Parameter: New column name 'asinhY'

Hyperbolic arccosine: 

Valid over the range (y > 1)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula if(Y>1,round(degrees(acosh(Y)), 2),null())
Parameter: New column name 'acoshY'

Hyperbolic arctangent: 

Valid over the range (-1 < y < 1)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula if(abs(y)<1,round(degrees(atanh(Y)), 2),null())
Parameter: New column name 'atanhY'

Results:

YatanhYacoshYasinhY
-4nullnull-120.02
-3nullnull-104.19
-2nullnull-82.71
-1.5nullnull-68.45
-1nullnull-50.5
-0.75-55.75null-39.71
-0.5-31.47null-27.57
00null0
0.531.47null27.57
0.7555.75null39.71
1nullnull50.5
1.5null55.1468.45
2null75.4682.71
3null101104.19
4null118.23120.02

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 0 rates

This page has no comments.