Page tree

Release 9.2


Contents:

   

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

Functions:

ItemDescription
ASINH Function Computes the arcsine 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.
ACOSH Function Computes the arccosine 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.
ATANH Function 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.

Also:

ItemDescription
ROUND Function Rounds input value to the nearest integer. Input can be an Integer, a Decimal, a column reference, or an expression. Optional second argument can be used to specify the number of digits to which to round.
DEGREES Function Computes the degrees of an input value measuring the radians of an angle. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.
NULL Function The NULL function generates null values.

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

See Also for EXAMPLE - Trigonometry Hyperbolic Arc Functions:

This page has no comments.