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.