For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Statistical

STDEV.P Function

Calculates the standard deviation based on the entire population.


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Syntax

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

  • Number1. Required. The first number argument corresponding to a sample of a population.

  • Number2,... Optional. Number arguments 2 to 255 corresponding to a population. You can also use a single array or a reference to an array instead of arguments separated by commas.

Applies To

Excel 2010 and above

Remarks

  • STDEVP assumes that its arguments are the entire population. If your data represents a sample of the population, you should calculate the standard deviation using STDEV or STDEV.S.
  • For large sample sizes, STDEV and STDEVP return approximately equal values, as do STDEV.S and STDEV.P.
  • The standard deviation is calculated using the "biased" or "n" method.
  • Cell C7 in the Example below shows an Excel version of the formula for this function, shown here:

Equation for Excel's STDEV.P function

Example

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Example of Excel's STDEV.P function.

Other Help

Related Functions

For a complete list of related functions, see Microsoft's page of Statistical Functions.

 

Charley's SwipeFile charts


Free Excel Dashboards