Returns the geometric mean of an array or range of positive numeric data.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
GEOMEAN(number1, [number2], ...)The geometric mean is a measure of central tendency that is often used for data sets involving growth rates or compound interest. It is calculated by multiplying all numbers together and then taking the n-th root, where n is the count of numbers. Note that all values must be greater than zero.
=GEOMEAN(1, 3, 9)結果: 3
The cube root of (1 * 3 * 9) which is the cube root of 27, resulting in 3.
The GEOMEAN function will return a #NUM! error if any value is less than or equal to zero.