Returns the geometric mean of an array or range of positive numeric data.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
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)Kết quả: 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.