Microsoft Office Tutorials and References
In Depth Information
DSTDEV
C
The multiplication of the cost
times the markup
A
Database range
Figure 3.5
The DPRODUCT
function multiplies
the numbers based on
parameters set in the
criteria range.
D
The criteria or
constraints to
use on the list
B
Field referenced
as a cell reference
DSTDEV
DSTDEV estimates the standard deviation of a population, based on a sample of selected entries
from the database.
=DSTDEV(database,field,criteria)
The DSTDEV function estimates the deviation of a population based on entries in the list or
database. The database in the syntax, shown previously, is the cell reference range or named range of
the database, while 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 also can
be a cell reference. The standard deviation is actually a standard error amount based on an
arithmetic mean formula. To view the actual formula on which the function is based, see the help file.
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.
Search JabSto ::




Custom Search