Documentation/Calc Functions/STDEVPA
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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
- For more information on standard deviations, visit Wikipedia's Standard deviation page.
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:
ODF standard:
Related (or similar) Excel functions:
STDEVPA