Documentation/How Tos/Calc: STDEVP function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 13:17, 13 September 2008 by Drking (Talk | contribs)

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. For a population of N values, the calculation formula is:
Calc pop stddev formula.png.

Example:

STDEVP(3; 3; 7; 7)

returns 2.

See also:

STDEVPA, STDEV, STDEVA, VARP

Statistical functions

Functions listed alphabetically, Functions listed by category

Issues:

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