VARP
The pre-2010 name for VAR.P. Same calculation, same result; kept so older workbooks open unchanged.
Syntax
VARP(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 |
|---|---|---|
=VARP(A2:A9) | 4 | |
=VARP(A2:A9)=VAR.P(A2:A9) | TRUE | Identical to VAR.P. |
Prefer VAR.P in new work
VARP 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
VARP is kept so older workbooks recalculate unchanged.
In a new sheet, VAR.P says what it computes. With the old
names, the only way to tell the population version from the sample one is to remember which has the P.
Excel compatibility
Matches Excel.