VAR
The pre-2010 name for VAR.S. Same calculation, same result; kept so older workbooks open unchanged.
Syntax
VAR(number1, [number2], ...)| Argument | Required | Description |
|---|---|---|
number1 | Required | A range or value. |
number2 | Optional | Further ranges or values. |
Examples
Every example below was executed against VisiGrid engine 0.54.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=VAR(A2:A9) | 4.57 | |
=VAR(A2:A9)=VAR.S(A2:A9) | TRUE | Identical to VAR.S. |
Prefer VAR.S in new work
VAR is the name Excel used before 2010, when the statistical functions were
split into explicitly named sample and population versions. Both names work and always agree, and
VAR is kept so older workbooks recalculate unchanged.
In a new sheet, VAR.S says what it computes. With the old
names, the only way to tell the sample version from the population one is to remember which has the P.
Excel compatibility
Matches Excel.