Documentation/How Tos/Calc: STDEVP function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 18:36, 4 April 2008 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


STDEVP

Returns the population standard deviation.

Syntax:

STDEVP(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers.
STDEVP returns the standard deviation where number1 to number30 are the entire population. If you only have a sample of the population use STDEV instead.

Example:

STDEVP(3; 3; 7; 7)

returns 2.

See also:

STDEVPA, STDEV, STDEVA, VARP

Statistical functions

Issues:

  • Calc assumes that logical values are 1 (TRUE) and 0 (FALSE). Excel ignores logical values.
Personal tools