STDEV in Collabora Office: Sample Standard Deviation and Numeric Range 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(argument1;[argument2];...)

The reference permits up to 255 arguments and requires at least two values. A range is one argument even when it contains many observations. These examples use English function names and semicolon separators.

For an all-numeric sample, the independent check is the square root of the squared-deviation total divided by n minus one. This model verifies the numbers below; it is not captured application output.

Enter 4, 6, 10 and 12 in A2:A5 as fictional elapsed minutes:

=STDEV(A2:A5)

Expected result: 3.651484, displayed to six decimal places. The mean is 8. Deviations are -4, -2, 2 and 4, whose squares are 16, 4, 4 and 16. Their total is 40; the sample variance is 40/3.

The output is in minutes, not squared minutes or percent. VAR.S addresses the related squared-unit measure.

Extend the same range by entering text Pending in A6 and leaving A7 genuinely empty:

=STDEV(A2:A7)

The expected result remains 3.651484 under the documented range-ignore rule. Now replace Pending with numeric 8. Five numeric values participate, with mean 8, squared-deviation total 40 and sample denominator 4. The new expected standard deviation is 3.162278.

Ignoring a label is different from inserting a measurement equal to the mean. Record which change occurred before explaining the new result.

In C2:C5 enter 7, 7, 9 and 9. This second sample also has mean 8, but its squared deviations total only 4:

=STDEV(C2:C5)

Expected result: 1.154701. Both samples have four observations and the same center; their differing standard deviations describe different dispersions.

The first sample’s result is the square root of ten times the second sample’s variance. Do not interpret a standard-deviation ratio as the same numerical ratio of variances.

Create B2 with =A2+100 and fill through B5, using the original four numeric readings. Values become 104, 106, 110 and 112. The mean becomes 108, but the deviations remain -4, -2, 2 and 4, so STDEV has the same expected 3.651484 result.

Multiplying each original reading by ten instead produces expected standard deviation 36.514837. Translation and rescaling are different operations. Keep full precision during arithmetic and round only the displayed result.

STDEV is still explicitly documented in Collabora Office 26.04. This guide does not label it retired merely because STDEV.S also names a sample-standard-deviation function. A shared statistical purpose does not certify identical invalid-input handling or every imported workbook behavior.

The range-ignore statement does not establish every direct text argument, formula-empty string, Boolean or source-error case. The source requires at least two values but does not give a complete error-code table. Inspect included observations rather than replacing a failed estimate with zero.

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