VAR.P
Calculate the variance when the data covers the whole population — the average squared distance from the mean.
Syntax
VAR.P(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.51.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=VAR.P(A2:A9) | 4 | The mean is 5; the squared distances from it sum to 32; 32 / 8 = 4. |
=STDEV.P(A2:A9)^2 | 4 | |
=VAR.P(5) | 0 |
The plain definition
VAR.P is variance exactly as it is defined: the average of the squared
distances from the mean. Nothing is estimated, so use it only when the data is
the complete population. For a sample, VAR.S corrects
for the bias of estimating from part of the group.
VARP is the pre-2010 name for the same function.
Excel compatibility
Matches Excel, including skipping text and logical values in ranges.