VHARMEAN function


VHARMEAN(variable[,filter]) returns the harmonic mean of a variable.

The harmonic mean is calculated as follows:

Harmonic mean

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


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...