Page 116 - Excel Data Analysis

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

EXCEL DATA ANALYSIS

FIND THE AVERAGE OF

A DATABASE RANGE

o find the average of specific imported database You must indicate the range that contains the imported
records, you can create a formula using the database values for the database argument. Also, because
T DAVERAGE function in your worksheet. An analyst Excel uses the column labels to match the information
can use this function to average only the records that match specified for the criteria argument, you must select the
certain criteria. For example, if you have an imported column labels as well as the database values. You reference
database list of computer equipment, you can find the the cell containing the label for the column of values you
average of the computer monitors in the list. Although Excel want to average as the field argument. You can also
calls this a database function, you can use it with any data specify a number, identifying the column position in the
list. See Chapter 2 for more information on working with selected list of the values. For example, to use the first
data lists in Excel. column, you type 1 for the value of the field argument.
There are three different arguments for the DAVERAGE Finally, you must create a range of cells containing your
function, and you must specify values for each of the criteria values. The criteria definition must consist of at least
arguments: two rows. The first row contains the column labels that you
want Excel to use for your results. The second row contains
=DAVERAGE(database, field, criteria) any criteria values. See p. 52-53 for more on criteria values.

FIND THE AVERAGE OF A DATABASE RANGE

DAVERAGE

⁄ Type the column headings ‹ Select the formula cell. ■ The Insert Function dialog Note: See Chapter 4 for more
for the database list. box displays. information on inserting functions.
› Click Insert ➪ Function.
¤ Type the criteria under the ˇ Select the DAVERAGE Á Click OK.
corresponding column label. function.

102