The AVERAGE() fucntion
returns the arithmetic mean of a distribution of
values.
- The syntax for the function
is AVERAGE (number 1 , number 2, ....number
n).
The arguments
for the function "number
1, number 2.." can be a series
of up to 30 values, a range of cells or a named
range.
The AVERAGE function
is a measure of the center for a range of data
points.It sums the given arguments and divides
by the number of arguments. For example: AVERAGE(3,8,4,6,2,5,7)
= 5.166667 as the sum of the arguments is 31 and
there are 6 arguments which gives 31/6 or written
in a different way 5.166667.
|
