ASIN macro

The ASIN macro is available only in Unica Campaign.

Syntax

ASIN(data [, units_keyword])

Parameters

data

The numerical values to compute the arc sine of. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your product.

units_keyword

This optional keyword determines whether the input values and results are interpreted as degrees or radians. Select one of the following:

RADIAN - Performs the calculations in radians (default)

DEGREE - Performs the calculations in degrees

If this parameter is not specified, the default is radians. (To convert from radians to degrees, divide by PI and multiply by 180.)

For more details on using keywords in Unica Campaign, see Format Specifications.

Description

ASIN calculates the arcsine of the values in the specified data range. The arcsine is the angle whose sine is the contents of each cell. ASIN returns one new column for each input column, each containing the arcsine of numbers in the corresponding input column.

If the keyword RADIAN is used, ASIN returns values in the range -π/2 to π/2. If the keyword DEGREE is used, ASIN returns values in the range -90 to 90.

Note: The cell contents of each specified column must have values between -1.0 and 1.0 inclusive. Otherwise, ??? is returned for each invalid input.

Examples

TEMP = ASIN(0.5) or TEMP = ASIN(0.5, 0) or TEMP = ASIN(0.5, RADIAN)

Creates a new column named TEMP containing the value 0.524 ( radians).

TEMP = ASIN(0.5, 1) or TEMP = ASIN(0.5, DEGREE)

Creates a new column named TEMP containing the value 30 (degrees).

TEMP = ASIN(V1)

Creates a new column named TEMP, where each value is the arcsine (in radians) of the contents of column V1.

TEMP = ASIN(V1:V3, 1)

Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the arcsines of the contents of column V1, the values of the VX column are the arcsines of the contents of column V2, and the values of the VY column are the arcsines of the contents of column V3. All values are in degrees.

TEMP = ASIN(V1[10:20])

Creates a new column named TEMP, where the first 11 cells contain the arcsines of the values in rows 10-20 of column V1 (in radians). The other cells in TEMP are empty.

TEMP = ASIN(V1[1:5]:V2)

Creates two new columns named TEMP and VX, each with values in rows 1-5 (the other cells are empty). The values in column TEMP are the arcsines of the corresponding rows of column V1, and the values in column VX are the arcsines of the corresponding rows of column V2. All values are in radians.

Related functions

Function Description
ACOS Computes the arc cosine of the contents of the specified data range
ACOT Computes the arc cotangent of the contents of the specified data range
ATAN Computes the arctangent of the contents of the specified data range
SIN Computes the sine of the contents of the specified data range