STDEV.P in Collabora Office: Whole-Population Standard Deviation and Centered Checks

• Introduced: original Collabora release and launch date are not established by the reviewed sources.
• Availability: currently documented in Collabora Office 26.04 desktop help.
• Platform scope: online and mobile deployments are not inferred from this desktop-help release.
• Checked: October 14, 2026. Function-specific documentation and independent calculations; no native Collabora execution.

=STDEV.P(argument1;[argument2];...)

The Collabora section lists up to 255 arguments and permits ranges. These controls contain ordinary numeric observations only. Its compact section does not establish all text, Boolean, empty-cell or error conversions, so another function’s rules are not silently substituted.

For a numeric population, compute the mean, square each centered difference, average those squares and take the square root. This independent model checks the examples without claiming native test output.

Enter 10, 10, 14 and 18 in A2:A5:

=STDEV.P(A2:A5)

Expected result: 3.316625, displayed to six decimal places. The mean is 13. Squared deviations are 9,9,1,25, with total 44. Dividing by four gives population variance 11, whose square root is about 3.316624790.

If the observations are minutes, this standard deviation is measured in minutes. It is not the mean absolute deviation: the latter would be (3+3+1+5)/4=3 for this dataset.

Put =AVERAGE(A2:A5) in D2. In B2 enter =(A2-$D$2)^2 and fill through B5. Then:

=SUM(B2:B5)/4
=SQRT(SUM(B2:B5)/4)

Expected results are 11 and 3.316625. The explicit count four is valid because every input in this fixture is numeric and included. Do not reuse that denominator after adding or excluding records.

The VAR.P guide explains the squared-unit companion measure. The helper calculation makes the mean and denominator visible for inspection.

Create C2 with =A2+7 and fill through C5. Values become 17,17,21,25, with mean 20. Their centered differences still equal -3,-3,1,5, so STDEV.P has the same expected 3.316625 result.

For values 20,20,28,36, obtained by doubling the original readings, the expected standard deviation is 6.633250. The variance quadruples from 11 to 44; the standard deviation doubles.

Unit changes and constant calibration offsets have different effects. Keep the transformation next to the calculation when comparing reports.

Add numeric 13 in A6 and evaluate A2:A6. The mean remains 13 and squared deviations still total 44, but the population count is now five. Expected standard deviation is 2.966479, from sqrt(8.8).

An observation at the mean does not contribute a centered square, yet it still changes the denominator. A zero contribution is different from an excluded observation.

The direct reference identifies COM.MICROSOFT.STDEV.P and places it outside the cited OpenFormula 1.3 standard. This records a formula-format namespace; it does not certify a successful interchange with every Excel version.

The currently documented STDEVP spelling has additional range-ignore wording in its own section. Those details are not promoted to STDEV.P without evidence. Singleton handling, exact error codes and mixed-data behavior remain held; the examples use at least four numeric values.

• Collabora Office 26.04: STDEV.P.
• Editorial testing standards.

Complete function-specific documentation reviewed. Worked outputs are independent mathematical or explicitly documented type-rule controls, not application screenshots or native test results. The stated unresolved boundaries retain their scope.