Purpose
Return value
Syntax
=ACOTH(number)
- number - The number to get the inverse hyperbolic cotangent of.
Using the ACOTH function
The Excel ACOTH function returns the inverse hyperbolic cotangent of a number. Given 2 as input, the function returns 0.549306144 as output.
=ACOTH(2) // returns 0.549306144
Explanation
The hyperbolic arc cotangent function is the inverse of the COTH function.
=ACOTH(COTH(x)) // returns x when x ≠ 0
The plot below shows the ACOTH function’s output in Excel.
Notes:
- The function returns a #NUM! Error for input greater than or equal to -1 and less than or equal to 1.
Image(s) courtesy of wumbo.net .
Purpose
Return value
Syntax
=ASIN(number)
- number - The value to get the inverse sine of. The number must be between -1 and 1 inclusive.
Using the ASIN function
The ASIN function, also called arc-sine, returns the inverse sine of a value. The input number must be between -1 and 1, inclusive. Geometrically, given the ratio of a triangle’s opposite side over its hypotenuse, the function returns the angle of the triangle. For example, given a ratio of 0.5 the function returns the angle of 0.524 radians.
=ASIN(0.5) // Returns 0.524 radians
Convert Result to Degrees
To convert the result from radians to degrees, multiply the result by 180/ PI() or use the DEGREES function. For example, to convert the result of ASIN(0.5) to degrees, you can use either formula below:
=ASIN(0.5)*180/PI() // Returns 30 degrees
=DEGREES(ASIN(0.5)) // Returns 30 degrees
Explanation
The graph of ASIN visualizes the output of the function from -1 to 1. ASIN is the inverse of SIN. However, because SIN is a periodic function, the output of ASIN is limited to the range from -π/2 to π/2.
Notes
- ASIN is the inverse of SIN
- To convert the result from radians to degrees multiply by 180/PI() or use the DEGREES function.
Graph courtesy of wumbo.net
