Microsoft Office Tutorials and References

In Depth Information

**HARMEAN**

Figure 11.20

You must select the

range where the results

are to appear before

you begin the
GROWTH

function.

HARMEAN

HARMEAN
returns the harmonic mean of a data set.

=HARMEAN(number1,number2,...)

The harmonic mean is the reciprocal of the arithmetic mean of reciprocals. The harmonic

mean is always less than the geometric mean and arithmetic mean.

Up to 30 arguments can be specified, including cell references or an

array. Each number in the data set must be positive.

NUMBER N

The equation for the harmonic mean is

If the data set is {5.50,6.00,6.25,5.75,6.00,7.00,7.25,7.00,7.5} the

arithmetic mean is 6.47.

geometric mean is 6.44.

harmonic mean is 6.40.

HYPGEOMDIST

HYPGEOMDIST
returns the hypergeometric distribution.

=HYPERGEOMDIST(sample_s,number_sample,population_s,number_population)

The
HYPGEOMDIST
function returns the probability of a given number of sample successes, and

is used when the population size is finite. Each obser vation is either a success or failure.

Figure 11.21 shows an example of the
HYPGEOMDIST
function.