Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0821

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:

D trans
RawWrangletrue
p03Value'asinhY'
Typestep
WrangleTextderive type: single value: round(degrees(asinh(Y)), 2) as: 'asinhY'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Valueround(degrees(asinh(Y)), 2)
p03NameNew column name
SearchTermNew formula

Hyperbolic arccosine: 

Valid over the range (y > 1)

D trans
RawWrangletrue
p03Value'acoshY'
Typestep
WrangleTextderive type: single value: if(Y>1,round(degrees(acosh(Y)), 2),null()) as: 'acoshY'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Valueif(Y>1,round(degrees(acosh(Y)), 2),null())
p03NameNew column name
SearchTermNew formula

Hyperbolic arctangent: 

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

D trans
RawWrangletrue
p03Value'atanhY'
Typestep
WrangleTextderive type: single value: if(abs(y)<1,round(degrees(atanh(Y)), 2),null()) as: 'atanhY'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Valueif(abs(y)<1,round(degrees(atanh(Y)), 2),null())
p03NameNew column name
SearchTermNew formula

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