The ACOS() function returns the arccosine (inverse cosine) of a given value. It calculates the angle whose cosine equals the input value, mathematically expressed as ACOS(x) = -i × ln(x + i√(1 - x²)). It's the inverse operation of the cosine function.
This function can be useful to measure the angular divergence between two moving averages as they drift apart over time.
Syntax
ACOS(Value)
Arguments
| Argument | Data type | Description |
| Value | Number | The cosine of the angle for which you want to calculate the arccosine. The input must be greater than or equal to −1 and less than or equal to 1 (between −1 and 1, inclusive). |
The ACOS() function returns a numeric value between 0 and π, inclusive.
Calculation engine functionality differences
This function is only available in the Polaris Calculation Engine.
Syntax example
ACOS(0.5)
Additional information
Returns NaN when Angle is NaN.
Excel equivalent
Examples
| Formula | Result |
ACOS(-0.5) | 2.094 |
ACOS(-0.5) * 180 / PI() | 120 |
TODEGREES(ACOS(-0.5)) | 120 |
Example 1: Employee performance and customer satisfaction correlation
Example 2: Portfolio diversification angle measurement
Example 3: Warehouse inventory accessibility scoring
Example 4: Sales rep activity and revenue alignment scoring
