Monday, August 7, 2017

SINH function

SINH function

Returns the hyperbolic sine of a number.

Syntax

SINH(number)

Number     is any real number.

Remark

The formula for the hyperbolic sine is:

Equation

Example set 1

Formula

Description (Result)

=SINH(1)

Hyperbolic sine of 1 (1.175201194)

=SINH(-1)

Hyperbolic sine of -1 (-1.175201194)

Example set 2

You can use the hyperbolic sine function to approximate a cumulative probability distribution. Suppose a laboratory test value varies between 0 and 10 seconds. An empirical analysis of the collected history of experiments shows that the probability of obtaining a result, x, of less than t seconds is approximated by the following equation:

P(x<t) = 2.868 * SINH(0.0342 * t), where 0<t<10

To calculate the probability of obtaining a result of less than 1.03 seconds, substitute 1.03 for t.

Formula

Description (Result)

=2.868*SINH(0.0342*1.03)

Probability of obtaining a result of less than 1.03 seconds (0.101049063)

You can expect this result to occur about 101 times for every 1000 experiments.

No comments:

Post a Comment