STDEV.P Function in LibreOffice Calc — Tested Examples
An explanation of LibreOffice Calc STDEV.P, including tested formulas, examples, expected results and common mistakes.
Tested: Examples checked in LibreOffice Calc 25.2.3.2. What this means
Calculates the standard deviation based on the entire population. For 2,4,6 the population standard deviation is the square root of 8/3, approximately 1.633.
Syntax and arguments
=STDEV.P(Number_)
LibreOffice Calc formulas generally separate arguments with semicolons (;).
| Argument | Explanation |
|---|---|
Number |
Number 1, number 2, … are numerical arguments which portray a population. |
Worked examples
Example 1: Calculate population standard deviation
=STDEV.P(2;4;6)
Expected result: 1.632993161855452. This value was returned in the LibreOffice Calc 25.2 test.
Example 2: Population standard deviation of 1, 2, 3
=STDEV.P(1;2;3)
Expected result: 0.816496580927726. This value was returned in the LibreOffice Calc 25.2 test.
How to interpret the result
For 2,4,6 the population standard deviation is the square root of 8/3, approximately 1.633.
Mistakes and troubleshooting
- Check inputs and assumptions: If the measurements are only a sample, prefer STDEV.S.
- Check argument order and format: Strings go in quotes, cell references do not. Functions that return arrays may require special entry.
- Verify your own data: Reproduce the example first. If your formula returns an error, inspect the referenced cells and individual argument values.
Related functions
Tested version and primary reference
2 example(s) on this page passed real calculations in LibreOffice Calc 25.2.3.2. This is not a claim about every possible input or other spreadsheet applications.