Microsoft Office Tutorials and References
In Depth Information
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
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.
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