Quick Navigation
STDEV.P Function
Summary
The STDEV.P function calculates the standard deviation for an entire population dataset. It measures how much individual data points vary from the population mean using the 'n' divisor method, perfect for complete datasets like all products in a batch.
Syntax
STDEV.P(number1,[number2],...)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number1 | Number |
Yes | Required first population value or cell range |
| number2 | Number |
No | Optional additional population values or ranges |
Using the STDEV.P Function
Use STDEV.P when analyzing complete populations like all employees in a company or every item in inventory. Enter numbers directly, reference cell ranges, or combine both. The function automatically skips non-numeric data in ranges while counting direct logical/text numbers in arguments.
Common STDEV.P Examples
Population Standard Deviation from Range
=STDEV.P(A2:A11)Calculates standard deviation for 10 tool strength measurements (1345,1301,1368,1322,1310,1370,1318,1350,1303,1299), returns 26.05 assuming complete production batch.
Multiple Direct Values
=STDEV.P(10,12,11,13,9,14)Computes population standard deviation for six test scores.
Mixed Arguments with Range
=STDEV.P(B2:B10,15,20)Combines range data with individual population values.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Arguments contain text that can't convert to numbers or error values
Solution: Ensure all arguments contain valid numbers or numeric ranges
#DIV/0! error
Cause: Single numeric argument provided
Solution: Provide at least two numbers for meaningful standard deviation
Notes
- Uses population formula: √[Σ(x-μ)²/n] where μ is population mean
- For large datasets, results approximate STDEV.S
- Logical values/text in direct arguments ARE counted
- Use STDEVPA to include logical/text from ranges
- Excel 2010+ only - use STDEVP in older versions
Compatibility
Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2007, Excel 2003, Excel XP
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+