DSTDEVP()
SyntaxDSTDEVP(database,field,criteria)
Definition. This function calculates the standard deviation of a population based on the numbers in a column in a list or database that match the specified criteria.
Arguments
database (required) The cell range that makes up the list or database
field (optional) Indicates which column is used in the function
criteria (required) The cell range containing the field names and the filter criteria
Background. The only difference between DSTDEVP() and DSTDEV() is that the DSTDEVP() calculation is based on the entire population and is not an estimate of the population value based on a sample.
See Also
You will find more information about standard deviations in the description of STDEV.P() in Chapter 12 and in ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
