Arcsine function

To use this function, choose Calc > Calculator.

Determines the angle corresponding to a specified sine. Arcsine is defined in radians from −π/2 to π/2. For example, the arcsine of 0.5 is π/6 or 0.5230 radians.

Arcsine is also called the inverse sine and can be represented by sin−1 x, arcsin x, or asin x.

Syntax

ASIN(number)

For number, specify the value or the column of values.

Example

Column Calculator expression Result
C1 contains 1 ASIN (C1) 1.570796326795

Uses

Arcsine can be used to transform data recorded in percentages or proportions (p) that follow a binomial distribution. The transformation makes the distribution of the data normal and stabilizes the variances. These are two important assumptions when using statistical analyses such as ANOVA or regression. The functions Transform count and Transform proportion also use arcsine to perform data transformations.