Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
VAR.P
VAR.P computes population variance by dividing the sum of squared deviations by n rather than n-1. Use it when the data range represents every member of the group you are studying, such as all products in a catalogue or all employees in a department.
Excel
=VAR.P(B2:B5)Google Sheets
=VAR.P(B2:B5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Product | Margin % |
| P1 | 18 |
| P2 | 32 |
| P3 | 25 |
| P4 | 11 |
=VAR.P(B2:B5)→61.25
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Reference the complete population data: =VAR.P(B2:B5).
- 2VAR.P divides by n, giving a slightly smaller result than VAR.S on the same data.
- 3Use this only when you have every observation in the population, not just a sample.
Need a version for your data?
Try: “Compute the population variance for all products' profit margins in the catalogue”