VGEOMEAN function

Description

VGEOMEAN(variable[,filter]) returns the geometric mean of a variable.

The geometric mean is calculated as follows:

Geometric mean

The geometric mean is undefined for a data set that contains zero or negative values.

Note

This function calculates a statistic on a variable. Be careful when you use this function in cells of the columns that correspond to the variable, because this actually adds a value to the variable which can lead to unexpected and faulty results. You can exclude the cell to avoid this.

Related functions

This site uses cookies to store information on your computer. More info...