VAR in WPS Spreadsheet: Sample Variance with Numeric Ranges
Calculate sample variance with VAR, check the n minus one denominator, and avoid mixing population and sample interpretations.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer
=VAR(A2:A5) estimates sample variance. For the numeric values 8, 10, 12, 14, its independently expected output is 6.666666667. Variance measures squared deviations, so if the observations are minutes, the result is in minutes squared.
Syntax and inputs
VAR(number1,number2,...)
number1 is the first value or range; additional values or ranges supply more observations. A single range can contain many observations. The historical lesson describes 1 to 30 arguments; that is not established as the current maximum for every build. These examples use one small numeric range.
The WPS lesson identifies VAR as sample variance and says text and logical values are ignored. This guide limits its calculations to clean numeric ranges rather than extending that statement to every combination of direct arguments, references and numeric text.
Worked worksheet: sampled packing times
Enter Minutes in A1, then 8, 10, 12 and 14 in A2:A5. These four jobs are treated as a sample of the wider packing process. In C2 enter:
=VAR(A2:A5)
Expected output: 6.666666667 minutes squared. The mean is 11. Deviations are -3, -1, 1 and 3; squared deviations are 9, 1, 1 and 9. Their sum is 20. Dividing by the sample denominator 4 - 1 gives 20/3.
Do not divide by four merely because there are four rows. That would give the population variance, 5, and answer a different statistical question.
Small controls
| Inputs in a separate numeric range | Formula pattern | Expected sample variance |
|---|---|---|
| 2, 4, 6 in E2:E4 | =VAR(E2:E4) |
4 |
| 7, 7, 7 in F2:F4 | =VAR(F2:F4) |
0 |
| 0, 0, 8, 8 in G2:G5 | =VAR(G2:G5) |
21.33333333 |
Zeros are actual observations in these controls. The all-equal case has zero spread even though the values themselves are nonzero.
Advanced example: combine groups without losing between-group spread
Enter 2 and 4 in J2:J3, and 10 and 12 in K2:K3. Each two-value group’s sample variance is 2. Now combine the observations:
=VAR(J2:J3,K2:K3)
Expected output: 22.66666667, not 2. The combined mean is 7, the squared deviations sum to 68, and the denominator is 3. Averaging the two group variances discards their differing means. Keep individual observations or sufficient count/mean/spread information when combining samples.
Troubleshooting and interpretation
- Use at least two numeric observations. The sample denominator is unusable with fewer; this guide does not assert an untested WPS error label for that case.
- If values imported as text are ignored, convert the intended measurement column to numbers before calculating. Check the included count with COUNT.
- Do not include totals, headers or measurements in different units in the same observation range.
- A variance is not a standard deviation. Taking its square root changes the units back to the measurement units.
- Sample-versus-population choice depends on the population you intend to describe, not a fixed row-count threshold. Exact mixed-data coercion and modern argument limits remain unverified.
The existing VAR.S guide covers a separately documented function identity. The reviewed VAR lesson does not establish a rename or universal interchangeability.
Availability and verification
The official WPS VAR lesson was fetched afresh on October 19, 2026. Its edition banner says WPS Office for Windows Personal. The lesson dates from 2019; it does not establish introduction or retirement dates, exact build coverage, or current Mac, Linux, web and mobile behavior. Examples are independently calculated expectations, not observed WPS outputs. Native execution and genuine current-application screenshots remain unverified.
Related guides
VAR.S, VARP, COUNT, STDEV. Browse the WPS function library.