DSTDEV Function Explained
The DSTDEV Function in Microsoft Excel calculates the standard deviation of a population based on a sample of numbers. It takes two arguments: a range of cells containing the sample data, and an optional argument indicating whether the data is a sample or a population. The function returns the standard deviation of the sample or population.
DSTDEV Function Syntax
DSTDEV(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 numbers for which you want to calculate the standard deviation.
- criteria: The range of cells that contains the conditions you specify. The database is filtered to include only the records that meet the criteria.