Page 117 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 103

WORKING WITH EXTERNAL DATA 5

The DAVERAGE function is one of twelve the functions require the same three argument
database functions that Excel provides to evaluate values. The following table gives a brief
manually created or imported databases. All of description of the other database functions.

FUNCTION DESCRIPTION
DCOUNT Counts the number of cells that contain numeric values and match the criteria.
DCOUNTA Counts the number of cells that contain a value and match the criteria.
DGET Returns the cell value that matches the specified criteria.
DMAX Finds the largest number in the column that matches the criteria.
DMIN Finds the smallest number in the column that matches the criteria.
DPRODUCT Multiplies the values that match the criteria and returns the product.
DSTDEV Finds the standard deviation of a sample of the values that match the criteria.
DSTDEVA Finds the standard deviation of the entire list of values that match the specified criteria.
DSUM Totals the values that match the criteria and returns the sum.
DVAR Estimates a sample variance of the values that match the criteria.
DVARP Estimates a population variance of the values that match the criteria.

■ The Function Arguments · Specify the range of cells ■ The average displays for
dialog box displays. containing the criteria the records that meet the
definition. specified criteria.
‡ Specify the reference for
the Database argument. Note: To learn how to specify a
range, see Chapter 1.
° Specify the cell reference
for the Field argument. ‚ Click OK.
103