DSTDEVP Function Explained
The DSTDEVP Function in Microsoft Excel calculates the standard deviation of a population based on a sample of numeric values. It takes up to 255 arguments, which can be numbers, cell references, ranges, arrays, or a logical value. It returns the standard deviation of the population based on the sample.
DSTDEVP Function Syntax
DSTDEVP(database, field, criteria)
- database: The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields.
- field: The column number in the list or database that contains the values to calculate.
- criteria: The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.