The geometric mean formula is:
GM = ( A * B * C ) ^ (1 / n )
Where: A, B, and C = sample data
n = is the number of samples, in this case 3
If there are only 2 sample data, the formula becomes:
GM = ( A * B ) ^ (1/2)
The calculation of the Geometric Mean becomes tedious as soon as the number of samples increases. Fortunately, modern spreadsheets can easily calculate this measure of central tendency. The OpenOffice formula for the Geometric Mean is:
=geomean( range of cells of the sample data )
No comments:
Post a Comment