The SIN() function returns the sine of a given angle. It's a basic trigonometric function that calculates the ratio of the length of the side opposite an angle to the length of the hypotenuse, of a right-angled triangle. It's mathematically expressed as SIN(x) = opposite / hypotenuse. In a unit circle, it represents the y-coordinate of a point.
This function can be useful to model repeating seasonal patterns in rolling forecasts.
Syntax
SIN(Angle)
Arguments
| Argument | Data type | Description |
| Angle | Number | The angle in radians for which you want to calculate the sine. Use the |
The SIN() function returns a numeric value between -1 and 1, inclusive.
Calculation engine functionality differences
This function is only available in the Polaris Calculation Engine.
Syntax example
SIN(PI() / 6)
Additional information
Returns NaN when Angle is NaN.
Excel equivalent
Examples
| Formula | Result |
SIN(PI() / 2) | 1.0 |
SIN(30 * PI() / 180) | 0.5 |
SIN(TORADIANS(30)) | 0.5 |
Example 1: Seasonal promotional spend optimisation
Example 2: Cyclic cash flow forecasting
Example 3: Seasonal inventory replenishment planning
Example 4: Shift staffing demand modeling
