The ASIN() function returns the arcsine (inverse sine) of a given value. It calculates the angle whose sine equals the input value, mathematically expressed as ASIN(x) = -i × ln(ix + √(1 - x²)). It's the inverse operation of the sine function.
This function can be useful to convert normalised performance ratios into angular scores within a rolling forecast model.
Syntax
ASIN(Value)
Arguments
| Argument | Data type | Description |
| Value | Number | The sine of the angle for which you want to calculate the arcsine. The input must be greater than or equal to −1 and less than or equal to 1 (between −1 and 1, inclusive). |
The ASIN() function returns a numeric value between −π/2 and π/2, inclusive.
Calculation engine functionality differences
This function is only available in the Polaris Calculation Engine.
Syntax example
ASIN(0.5)
Additional information
Returns NaN when Angle is NaN.
Excel equivalent
Examples
| Formula | Result |
ASIN(-0.5) | -0.5236 |
ASIN(-0.5) * 180 / PI() | -30 |
TODEGREES(ASIN(-0.5)) | -30 |
Example 1: Deal closure probability mapping
Example 2: Credit risk exposure angle analysis
Example 3: Supplier on-time delivery reliability scoring
Example 4: Training assessment pass rate sensitivity analysis
