Documentation/How Tos/Calc: STDEVP function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 12:33, 20 November 2009 by OOoWikiBot (Talk | contribs)

Jump to: navigation, search


Returns the population standard deviation.


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.


STDEVP(3; 3; 7; 7)

returns 2.


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


Personal tools