Home > Articles

  • Print
  • + Share This
This chapter is from the book

DSTDEVP

DSTDEVP returns the calculation of the standard deviation of a population, based on the sum of the whole population.

=DSTDEVP(database,field,criteria)

The DSTDEVP function calculates the standard deviation based on an entire population. The database is the cell reference range or named range of the database. In this syntax, the field is referenced as the column number from left to right. The criteria is a range that is referenced, and the function operates from the parameters set. The field can also be a cell reference. In the example in Figure 3.6, the true standard deviation in the communities' population for the year 2001 is 1,233. Notice how the criteria takes into account a vertical range of towns the criteria calculates from. If the range were B13:B15, it would only include the populations of Avon and Albany in the year 2001.

Figure 3.6 The DSTDEVP function calculates the true standard deviation of an entire population, in this case, all the communities in the year 2001.

  • + Share This
  • 🔖 Save To Your Account