# STDEV.P function in Excel

> STDEV.P measures how spread out a set of numbers is when those numbers are the entire population: every employee, every shift, every student in the class.

Source: https://spreadsheetpractice.com/functions/stdev-p · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** STDEV.P measures how spread out a set of numbers is when those numbers are the entire population: every employee, every shift, every student in the class.
- **Syntax:** `=STDEV.P(number1, [number2], ...)`
- **Most common use:** `=STDEV.P(B2:B9)` returns 10.23 (The whole class took the test, so this is a population)
- **Available in:** Excel 2010 and later
- **Category:** [Statistical functions](https://spreadsheetpractice.com/functions/category/stats)
- **Returns:** The population standard deviation.
- **Google Sheets:** Also available in Google Sheets.

## What it does

STDEV.P measures how spread out a set of numbers is when those numbers are the entire population: every employee, every shift, every student in the class. It divides by the count of values rather than one less, so it comes out slightly smaller than STDEV on the same data.

## Syntax

`=STDEV.P(number1, [number2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `number1` | Required | The first number, cell or range in the population. |
| `number2` | Optional | More numbers, cells or ranges, up to 255 in total. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| F2 | `=STDEV.P(B2:B9)` | 10.23 | The whole class took the test, so this is a population |
| F3 | `=STDEV(B2:B9)` | 10.94 | The sample version is slightly larger on the same scores |
| F4 | `=STDEV.P(B2:B9)/AVERAGE(B2:B9)` | 12.9% | Spread as a share of the average (coefficient of variation) |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Student | Score |  |  | Check | Result |
| 2 | Ana | 88 |  |  | Population spread | 10.23 |
| 3 | Raj | 72 |  |  | Sample spread | 10.94 |
| 4 | Lee | 95 |  |  | Spread vs average | 12.9% |
| 5 | Kim | 64 |  |  |  |  |
| 6 | Mo | 81 |  |  |  |  |
| 7 | Ivy | 77 |  |  |  |  |
| 8 | Sam | 90 |  |  |  |  |
| 9 | Tia | 69 |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Using STDEV.P on a sample | If the data is a sample of a bigger group, STDEV.P understates the spread. Use STDEV.S (or STDEV) instead. |
| #NAME? in an old file | STDEV.P arrived in Excel 2010. In Excel 2007 and earlier, use STDEVP, which gives the same result. |

## Tips

- If you're unsure whether you have a sample or a population, ask whether you could collect more values of the same kind. If yes, it's a sample.

## Related functions

- [STDEV](https://spreadsheetpractice.com/functions/stdev): STDEV measures how spread out a set of numbers is, treating them as a sample of a larger group.
- [VAR](https://spreadsheetpractice.com/functions/var): VAR returns the variance of a sample: the average squared distance of each value from the mean.
- [AVERAGE](https://spreadsheetpractice.com/functions/average): AVERAGE adds up the numbers you give it and divides by how many numbers there are.

## Questions

### What is the difference between STDEV.P and STDEV.S?

STDEV.P divides by n and describes a complete population. STDEV.S divides by n-1 and estimates the spread of a larger group from a sample.

### Is STDEV.P the same as STDEVP?

Yes. STDEVP is the older name; both return the same value.

## Practice

A graded STDEV.P exercise ("Output spread per line") is on [the STDEV.P page](https://spreadsheetpractice.com/functions/stdev-p). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
