  >   >   >

# STDEV.P Function

## Calculates the standard deviation based on the entire population.

 by Charley Kyd, MBAMicrosoft 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: Example

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

Related Functions

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