Nov 07, 2001

Since a geometric mean is the anti-log of the sum of the logs divided by the number of samples and the log of zero (0) is not defined, three workarounds are commonly used. One must check with their local regulatory agency for the proper procedure as they vary regionally throughout the US.

1.If any value is zero (0), one is added to each value in the set and then one is subtracted from the result.

2.Blank and 0 values are ignored in the calculation.

3.Zero (0) values are converted to one (1) for the calculation.

For example: The actual readings are 100, 50, 0, 25, 0, 60.

Method 1 would convert them to 101, 51, 1, 26,1, 61 and their logs are 2.0043, 1.7076, 0, 1.4150, 0, 1.7853; the sum is 6.9122 divided by 6 = 1.15203. The antilog is 14.14.1916 minus 1 = 13.1916.

Method 2 would convert them to 100, 50, BLANK, 25, BLANK, 60 and their logs are 2, 1.6990, BLANK, 1.3979, BLANK, 1.7782; the sum is 6.8751 divided by 4 = 1.7188. The antilog is 52.3317.

Method 3 would convert them to 100, 50, 1, 25, 1, 60 and their logs are 2, 1.6990, 0, 1.3979, 0, 1.7782; the sum is 6.8751 divided by 6 = 1.1458. The antilog is 13.9909.

In summary, the three methods return three different answers; 13.1916, 52.3317 and 13.9909.

These methods either require invalid entries or the spread sheets must be modified when the calculation is made. Programs exist where the data is entered correctly and the proper rule is invoked when the calculation is made.

4020 Peggy Rd. SE

Suite K

Rio Rancho, NM 87124

United States

800-677-0067

4020 Peggy Rd. SE

Rio Rancho

United States

800-677-0067

Sep 30 2016

In honor of Chicago meteorologist Tom Skilling's 38 years of educating the public on weather activity in the Chicago region, the Metropolitan Water...

Sep 30 2016

Milton Roy launched the PROTEUS line of Intelligent Metering Pumps.
“The most extensive voice-of-the-customer program in the history of Milton Roy...

Sep 30 2016

The U.S. Environmental Protection Agency (EPA) announced funding to six universities to work with local communities to better understand the economic...