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.
Search JabSto ::




Custom Search