Which must be entered by pressing CTRLSHIFTENTER. However each argument can be an array of values or a range of. The resultant geometric mean in this case will be 2590.
5th Square Root of 1 005 1 01 1 02 1 05 1 02 1 -003621 Multiply the result by 100 to calculate the percentage.
The arithmetic mean would be 4 92 65. How you calculate the geometric mean is rather easy-you use the GEOMEAN function built into Excel. Calculating A Geometric Mean With Some Negative Values - Excel View Answers I am trying to work out how to calculate the geometric mean of a series of values some of which are negative ie. The number of data points to exclude is provided as a percentage.