GEOMEAN

The GEOMEAN function returns the geometric mean of the specified number values.

GEOMEAN(pos-num, pos-num…)

pos-num: A number greater than 0.

pos-num…: Optionally include one or more additional positive numbers.

Notes

  • GEOMEAN multiplies the arguments to arrive at a product and then takes the root of the product that is equal to the number of arguments.

Example

=GEOMEAN(5, 7, 3, 2, 6, 22) returns 5.50130264578853. This is calculated by first determining the product of the arguments [5*7*3*2*6*22=27, 720], and then taking the 6th root (since there are six arguments) thereof [27720^(1/6)=5.50130264578853].

See alsoAVERAGEHARMEAN
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Naudingas?
Ženklų limitas: 250
Didžiausias ženklų limitas yra 250.
Dėkojame už atsiliepimą.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.