VARP in Collabora Office: Calculate Variance for a Complete Population
Use Collabora VARP with the population denominator, reproducible centered squares and explicit missing-data controls.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: for 2, 4, 6 and 8 in A2:A5, =VARP(A2:A5) has independently expected result 5. VARP divides the sum of centered squares by the number of usable observations.
Syntax and population convention
=VARP(Argument1 [; Argument2 ...])
The dedicated Collabora help describes variance for an entire population and permits up to 255 arguments, including references and ranges. Ordinary text and empty cells inside a referenced range are ignored.
The current source uses the population denominator n rather than n-1. A single numeric observation therefore has population variance zero; an empty numeric dataset cannot supply a defined average squared deviation.
This guide retains the exact documented VARP function identity. The P convention concerns the denominator and statistical interpretation, not whether the application has checked that every member of a real population is present.
Example 1: reconstruct the result from deviations
Put 2,4,6,8 in A2:A5. Their mean is 5. In B2 enter =A2-AVERAGE($A$2:$A$5) and fill down, giving -3, -1, 1 and 3.
In C2 enter =B2^2 and fill down. The squared values are 9,1,1,9, totaling 20. Dividing by the four observations gives 5.
The manual check is =SUM(C2:C5)/COUNT(A2:A5) for this complete numeric fixture. Keep the original values and calculated mean available so the centered-square total can be independently audited.
Example 2: compare sample variance explicitly
For the same four values, VAR uses denominator three and gives 20/3, approximately 6.666666667. The population result remains five.
A smaller population variance here does not mean that one function is more accurate. They implement different definitions. Whether the four observations are the whole population of interest or a sample is a property of the analysis, not of the spreadsheet’s row count.
For n>1 on the same usable observations, VARP=VAR*(n-1)/n. This denominator check is useful when reproducing a calculation from another report with an unstated convention.
Advanced application: check units and transformations
Population variance has squared units. The square root of five, approximately 2.236067977, is the population standard deviation in the original measurement unit.
Adding ten to every observation leaves variance 5. Multiplying every observation by two gives population variance 20. Multiplying by negative two gives the same variance twenty because squared deviations remove the sign.
These transformation checks help reveal inconsistent unit conversions. A positive unit conversion changes variance by the square of its scale factor, while a shared offset alone should not change it mathematically.
Advanced application: distinguish zero spread from missing data
For the complete population 7,7,7, VARP has independent result 0 because every value equals the mean. A population containing a single value seven also has mathematical variance zero.
A referenced range containing 2,4,“note”,blank,6,8 ignores the text and empty cell under the documented range behavior, leaving the original variance five.
Replacing those two positions with actual numeric zeros changes the population to 2,4,0,0,6,8. Its independent variance is 80/9, approximately 8.888888889. The original missing entries and the new zero measurements are not equivalent.
Errors and troubleshooting
A zero result can describe a real constant population; it is not a reliable signal that all required observations were supplied. Check numeric count and the intended population membership separately. An empty range should not be treated as a population of zero-valued observations.
The source uses centered squared deviations and division by the usable count. Its empty-input/error paths and all text, Boolean or matrix conversions are not newly verified in a native application. The guide uses ordinary numeric cells and explicitly documented referenced-range omission behavior.
When results differ from another tool, compare the denominator, included observations, input units and missing-data policy before changing formulas. A variance value by itself cannot establish a distribution family or explain why observations differ.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help. The cited help snapshot was retrieved on 2026-10-13 and hash-verified October 15, 2026. Desktop documentation does not establish Online or mobile support. First introduction and last functioning release are unknown in this evidence.
No native Collabora Office execution occurred. All numerical results are independent mathematical expectations, with English names and semicolon argument separators. Native error displays, all coercions and extreme numerical behavior are not certified.
Implementation statements are corroborated by Collabora current engine source, retrieved October 15, 2026. This is moving-main source evidence, not a pinned desktop 26.04 binary or execution.