Statistical
STDEV.P Function
Calculates the standard deviation based on the entire population.
by
Charley Kyd, MBA Microsoft Excel MVP, 20052014
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.
