STDEV
Estimates the standard deviation based on a sample.
Syntax
STDEV(Number 1;number 2;...number 30)
*Number 1, number 2, ... number 30* are numerical values or ranges
representing a sample based on an entire population.
Example
=STDEV(A1:A50) returns the estimated standard deviation based on the
data referenced.
NORMDIST
Returns the density function or the normal cumulative distribution.
Syntax
NORMDIST(Number; Mean; STDEV; C)
*Number* is the value of the distribution based on which the normal
distribution is to be calculated.
*Mean* is the mean value of the distribution.
*STDEV* is the standard deviation of the distribution.
*C* = 0 calculates the density function; *C* = 1 calculates the
distribution.
Example
=NORMDIST(70; 63; 5; 0) returns 0.03.
=NORMDIST(70; 63; 5; 1) returns 0.92.
Frank Lohr wrote:
Hi List,
where can I find the formulas to the functions implemented in OOo-Calc? I need
the formula für NORMVERT() or NORMDIST()
greetings
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
