Jump to content

Documentation/Calc Functions/STDEVPA

From The Document Foundation Wiki

Function name:

STDEVPA

Category:

Statistical Analysis

Summary:

Calculates the population standard deviation of a set of numbers.

STDEVPA is a variant of the STDEVP function. The main difference between the two is that STDEVP ignores cells containing text, whereas STDEVPA treats text values as the number 0.

Syntax:

STDEVPA(Number 1[; Number 2[; ...[; Number 255]]])

Returns:

Returns a non-negative real number, which is the population standard deviation of the supplied numbers.

Arguments:

Number 1, Number 2, ..., Number 255 give the set of real numbers for which the population standard deviation is to be calculated. Each argument may be a value or an expression, a reference to a single cell, a reference to a cell range, the name of a named or database range, or an inline array.

Note that although STDEVPA can accept up to 255 arguments, each argument could specify a range of cells. This means that the number of real numbers processed could be many more than 255.

The following conditions (including errors) may be encountered:

  • Text strings are treated as the number 0.
  • Empty cells are ignored.
  • If no numbers are supplied, then STDEVPA reports a #DIV/0! error.
  • If only one number is supplied, then STDEVPA returns 0.

Additional details:

  • The formula for the population standard deviation ([math]\displaystyle{ \sigma }[/math]) is:
[math]\displaystyle{ \sigma\:=\:\sqrt{\frac{1}{n}\sum_{i=1}^{n}(x_{i}-\mu)^2} }[/math]
where
  • [math]\displaystyle{ n }[/math] is the size of the population
  • [math]\displaystyle{ x_{i} }[/math] is the i-th value in the population
  • [math]\displaystyle{ \mu }[/math] is the population mean

Examples:

Formula Description Returns
=STDEVPA(A1:A6) where cells A1:A5 contain the values 1, 2, 3, 4, and 5 respectively, with cell A6 empty. Here the function calculates the population standard deviation of the five values in cells A1:A5, ignoring the empty cell A6. 1.4142135623731
=STDEVPA(A1:A6) where cells A1:A5 contain the same values as in the previous example, with cell A6 containing the string "Calc functions". Here the function calculates the population standard deviation of the five values in cells A1:A5 and the value 0 allocated for the text string in cell A6. Note that the formula =STDEVPA(1; 2; 3; 4; 5; 0) returns the same value. 1.70782512765993
=STDEVPA(3; 4; 5; 6; 2; 3; 1; "LibreOffice") Here the function calculates the population standard deviation of the first seven values passed as individual arguments, along with the value 0 allocated for the text string in the final argument. Note that the formula =STDEVPA(3; 4; 5; 6; 2; 3; 1; 0) returns the same value. 1.87082869338697
=STDEVPA({3, 4, -5, 6.05, 2, 3, -1.5}) Here the function calculates the population standard deviation of the seven values passed in an inline array. 3.43916518109514

Related LibreOffice functions:

AVERAGE

AVERAGEA

STDEV

STDEV.P

STDEV.S

STDEVA

STDEVP

VAR

VAR.P

VAR.S

VARA

VARP

VARPA

ODF standard:

Section 6.18.75, part 2

Related (or similar) Excel functions:

STDEVPA