Microsoft Office Tutorials and References

In Depth Information

**Syntax**

Caution

The arguments must be either numbers or names, arrays, or references

that contain numbers. If an array or a reference argument contains

text, logical values, or empty cells, those values are ignored.

However, cells that contain the value 0 are included. If any data

point is less than or equal to 0, GEOMEAN returns a #NUM! error.

To find the geometric mean of 10 numbers, you multiply the 10 numbers together

and raise the sum to the 1/10 power. Excel lets you do this quickly with

GEOMEAN.

Syntax

=GEOMEAN(number1, number2,...)

The GEOMEAN function returns the geometric mean of an array or a range

of positive data. For example, you can use GEOMEAN to calculate average

growth rate, given compound interest with variable rates.

The arguments number1, number2, ... are one to 255 arguments for which you

want to calculate the mean. You can also use a single array or a reference

to an array instead of arguments separated by commas.

Using

Using
HARMEAN

to Find Average Speeds

The typical averaging function fails when you are measuring speeds over a

period of time. Suppose that your exercise regimen is 5 minutes of walking at 2

mph, 25 minutes of running at 5 mph, and then 10 minutes of jogging at 3 mph. If

you took the average of (2, 5, 5, 5, 5, 5, 3, 3), you would assume that you aver-

aged 4.125 miles per hour.

The actual calculation for average speed would be to take the reciprocals

of each speed, average those values, and then take the reciprocal of the res-

ult. In the exercise example, you would average (1/2, 1/5, 1/5, 1/5, 1/5, 1/5, 1/3, 1/3)

to obtain 13/48. Then you would take the reciprocal, 48/13, to find the actual

average speed of 3.69 mph.

HARMEAN
to Find Average Speeds

Syntax:

=HARMEAN(number1,number2,...)