Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
STDEV.P
STDEV.P computes standard deviation using the population formula (dividing by n), treating the provided range as the complete dataset rather than a sample. Use it when your data represents every member of the group you are analysing, not a subset.
Excel
=STDEV.P(B2:B5)Google Sheets
=STDEV.P(B2:B5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Student | Score |
| Alice | 78 |
| Bob | 92 |
| Carol | 85 |
| Dave | 68 |
=STDEV.P(B2:B5)→8.8705974996
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: =STDEV.P(B2:B5).
- 2STDEV.P divides by n (not n-1), giving a slightly smaller value than STDEV.S on the same data.
- 3Use this only when the range contains every observation in the group of interest.
Need a version for your data?
Try: “Find the standard deviation of all exam scores for the entire class (full population)”