Microsoft Office Tutorials and References

In Depth Information

**AVERAGEA**

AVERAGE
is one of the most widely used functions by Excel users. It is calculated by taking the

sum of the values in a data set and dividing by the number of values in the data set. Refer to

Figures 11.1 and 11.2 for examples of the
AVERAGE
function.

You can specify up to 30 arguments for the
AVERAGE
function. The

arguments can be cell references, arrays, or range names. Blank

cells or cells containing text or logical values are ignored. Cells that

contain a zero (0) are included in the Average calculation.

NUMBER N

AVERAGEA

The
AVERAGEA
function calculates the average of the
values
in the list of arguments.

=AVERAGEA(value1,value2,...)

Similar to
AVERAGE
, the
AVERAGEA
function calculates the average of its arguments. The difference

is that
AVERAGEA
does not ignore text or logical values (TRUE and FALSE). Text and FALSE are

evaluated as zero (0) and TRUE is evaluated as one (1).

Cells that contain a zero (0), text, or logical values are included in the

AVERAGEA
calculation. Arguments can be cell references, arrays, or range

names. Blank cells are ignored. You can specify up to 30 arguments for

the
AVERAGEA
function.

VALUE N

Figure 11.2

Text arguments like

“new account” evaluate

to zero and are factored

into the
AVERAGEA

function.

BETADIST

BETADIST
returns the cumulative beta probability density function.

=BETADIST(x,alpha,beta,A,B)

Is the value between
A
and
B
at which to evaluate the function, so that

A<=X<=B
.

X