STDEVPA Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Statistical module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Selected formulas ran through the official 25.04.2 engine library. Source and independent mathematics were checked. This is engine evidence, with no GUI-cell or import verification; 26.08.2 was source-checked only.

STDEVPA calculates the population standard deviation of the full-value list. The denominator is n, rather than STDEVA’s n−1. In the tested engine, text that parses numerically contributes that number, failed numeric text contributes zero, and booleans contribute 1 or 0. Function-specific official reference.

=STDEVPA(value1[;value2;...])

Supply one or more values, arrays or ranges. A single included observation has population standard deviation zero. These engine fixtures use explicit scalar lists and inline arrays. Brackets indicate optional arguments and are not entered in the formula. Registration and implementation.

The engine and mathematical columns are separate. Results are rounded to twelve decimal places, or thirteen significant digits in scientific notation for very small or large values. This is a display choice, not an accuracy guarantee. Inline arrays in braces are formula values, not a workbook-import test. Their semicolons separate columns and vertical bars separate rows. Strings remain explicitly quoted, and booleans use TRUE()/FALSE().

For the complete population 1,2,3, the squared deviations total 2. =STDEVPA(1;2;3) is sqrt(2/3) ≈ 0.816496580928. Use this population definition when those listed values are the complete set you intend to describe.

For 1,2,text “9”, the total squared deviation is 38 and the count is 3, so the result is sqrt(38/3)≈3.559026084010. For 1,2,text “abc”, the third value is zero and the result is again sqrt(2/3). Counting a zero-valued text entry is not the same as excluding it.

Squaring STDEVPA returns the corresponding population variance. The executed =STDEVPA(1;2;3)^2 is approximately 2/3; last-place rounding can remain because the intermediate square root is rounded.

For n>1, the sample standard deviation is STDEVPA×sqrt(n/(n−1)). A common shift leaves either statistic unchanged, while multiplying all numeric values by a multiplies standard deviation by abs(a). These identities concern the converted numeric list, so settle text and logical-value policy first.

The executed advanced check was:

=STDEVPA(1;2;3)^2

Its engine result was 0.666666666667.

A singleton, an empty string alone or a constant list gives 0 in the tested calls. A call with no arguments gives #VALUE!; an existing division error propagates. Source treats a genuinely empty cell differently from an explicit empty string. The present evidence does not include GUI-cell empty-range testing.

• Function-specific implementation
• Versioned function help
• Defaults helper
• Aggregation helper
• Average helper
• Deviations helper
• Stddev helper
• Conversion helper
• Array Parser helper

The statistical module and value-calculation helpers are byte-identical between the inspected 25.04.2 and 26.08.2 sources. That comparison supports the source discussion but does not establish later-version execution, GUI-cell behavior or other locales.

STDEVP, STDEV, AVERAGE.