ACOS
Syntax
ACOS( data [, units_keyword ])
Parameters
data
The numerical values to compute the arc cosine value of. This parameter can be a constant value, a column, a cell range, or an expression that evaluates to any of these types. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® Unica® product.
units_keyword
This optional keyword determines whether the input values and results are interpreted as degrees or radians. Select one of the following values:
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 IBM® Unica® Campaign, see Format Specifications.
For more details on using keywords in IBM® Unica® PredictiveInsight, see Format Specifications.
Description
ACOS calculates the arccosine of the values in the specified data range. The arccosine is the angle whose cosine is the contents of each cell. ACOS returns one new column for each input column, each containing the arccosine of numbers in the corresponding input column.
If the keyword RADIAN is used, ACOS returns values in the range 0 to π. If the keyword DEGREE is used, ACOS returns values in the range 0 - 180.
*
Examples
TEMP = ACOS(0) or TEMP = ACOS(0, 0) or TEMP = ACOS(0, RADIAN)
Creates a column named TEMP containing the value 1.571 (pi/2 radians).
TEMP = ACOS(0, 1) or TEMP = ACOS(0, DEGREE)
Creates a column named TEMP containing the value 90 (degrees).
Creates a column named TEMP, where each value is the arccosine (in radians) of the contents of column V1.
Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the arccosines of the contents of column V1, the values of the VXcolumn are the arccosines of the contents of column V2, and the values of the VY column are the arccosines of the contents of column V3. All values are in degrees.
Creates a new column named TEMP, where the first 11 cells contain the arccosines of the values in rows 10-20 of column V1 (in radians). The other cells in TEMP are empty.
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 arccosines of the corresponding rows of column V1, and the values in column VX are the arccosines of the corresponding rows of column V2. All values are in radians.
Related Functions