Syntax. SINH(number)
Definition. This function returns the hyperbolic sine of a number.
Argument
number (required) Any real number
Background. The hyperbolic sine belongs to the hyperbolic functions which are (like the circle functions) defined for all real and complex numbers. (However, Excel allows only real arguments, not complex arguments, for hyperbolic functions.) The formula for the hyperbolic sine is:
A hyperbolic sine is shown in Figure 16-29. The hyperbolic sine is often used for research and development in engineering and natural sciences.
Examples. Some examples of this function are:
=SINH(0)
returns 0
.
=SINH(0.5)
returns 0.52109531
.
=SINH(-0.5)
returns -0.52109531
.
One example in Excel Help refers to an empiric cumulative probability distribution. These distribution functions are used for real test series if the behavior of the observed system or its components is not ideal; that is, if the requirements and assumptions for a normal or Poisson distribution are not met.
In this case, a cumulative distribution function, such as a function based on the hyperbolic sine, might be better suited.