Returns the geometric mean of an array or range of positive numeric data.
이 함수는 Google Sheets에서도 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.