Practice free

STDEV.P function

STDEV.P returns the population standard deviation, a measure of spread when your data is the entire group rather than a sample. Use STDEV.S for samples.

Example

Read it as a sentence: work out the standard deviation of A1:A8 treating those values as the whole population, which gives 2.

Practice this in the app

Syntax

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

Arguments in [square brackets] are optional.

number1 (required)
First number or range.
number2 (optional)
More numbers or ranges.

Returns: The population standard deviation.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=STDEV.P({2,4,4,4,5,5,7,9}) 2 Array constant
=STDEV.P(10,"20",TRUE) 7.760297818 Direct args: number, text-number, TRUE
=STDEV.P(5) 0 Single number
=STDEV.P({1,"2",TRUE,3}) 1 Array with text and boolean
=STDEV.P(Data!A1:A8) 2 Range of numbers
=STDEV.P(Data!B1:B8) 12.47219129 Mixed range: num, text-number, TRUE, blank, text, FALSE
=STDEV.P(10,"abc") #VALUE! Direct arg: non-numeric text
=STDEV.P(Data!C1:C5) #N/A Range containing #N/A

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • Use STDEV.S for samples.
  • Ignores text and logicals in ranges.

Where it works

Excel
STDEV.P arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, but behaves differently: `STDEVP`. Sheets has STDEVP and STDEV.P.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .