STDEVP in Collabora Office: Population Spread with Text and Empty Range Cells

• 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.

=STDEVP(argument1;[argument2];...)

The function accepts up to 255 arguments, including cell ranges. Decide which records form the population before calculating. All items completed during one fixed reporting window can be a population for describing that window, yet a sample for questions about a larger process.

The independent population model divides the squared-deviation total by n and takes the square root. The following outputs are mathematical checks rather than native execution results.

Enter 2, 4, 4 and 6 in A2:A5:

=STDEVP(A2:A5)

Expected result: 1.414214. The mean is 4, deviations are -2, 0, 0 and 2, and squared deviations total 8. Population variance is 8/4=2.

The related sample model would divide by three and give standard deviation 1.632993. The choice follows the question’s population, not whichever result looks more favorable.

Add text Review in A6 and leave A7 empty. Extending STDEVP to A2:A7 still gives expected 1.414214, following the source’s range-ignore rule.

Replace Review with numeric 0. Now five measurements participate, their mean is 3.2, and squared deviations total 20.8. Expected population standard deviation becomes 2.039608, from sqrt(20.8/5).

The zero changes the center and denominator. It is not equivalent to keeping an unmeasured row labeled Review.

Put 2, 2 in C2:C3 and 6, 6 in D2:D3. Each two-value group’s population standard deviation is zero. For their combined range arguments:

=STDEVP(C2:C3;D2:D3)

Expected result: 2. The combined center is 4, with squared deviations 4,4,4,4. Averaging the two zero standard deviations would miss the difference between their centers.

Retain the individual observations or enough group information for the combined question. A single group standard deviation cannot describe all differences between groups.

For 2,4,4,6,2,4,4,6, the mean stays 4, count doubles to 8 and squared deviations double to 16. The population model therefore still gives sqrt(2), approximately 1.414214.

This invariance is useful as an arithmetic check. It does not show that duplicated records are harmless: they change the record count and can distort other statistics or reporting totals.

STDEVP remains explicitly documented in Collabora Office 26.04. STDEV.P is another documented population-standard-deviation spelling; its separate page does not automatically prove a complete alias, type-conversion or file-compatibility equivalence. No retirement date is established here.

Only the stated range-text and genuine-empty-cell behavior is certified from this source. Direct text arguments, numeric text, Boolean values, error-containing ranges and singleton outcomes remain unverified. Formatting a cell to look empty is not proof that it has no content.

• Collabora Office 26.04: STDEVP.
• 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.