Talk:Documentation/Calc Functions/HARMEAN

SF Comments

 * (1) Summary. Suggest change “sequence” to “set of numbers”. Maybe add a second sentence as follows – “The harmonic mean is calculated by dividing the number count by the sum of the reciprocals of each number in the set.”
 * (2) Returns. Suggest change “a sample” to “the set of numbers”.
 * (3) Arguments, 1st paragraph. I am not sure that a reference to “random” is relevant. Maybe change “that represent a random sample” to “for which the harmonic mean is to be calculated”.
 * (4) Arguments, bullet. Insert “or” before “equal”. What about cells that are blank or contain non-numeric data?
 * (5) Additional details, general. Can we include a link to the relevant Wikipedia page?
 * (6) Additional details, text after formula. Could we change this to the following – “where ai are the set of numbers passed as arguments and n is the size of that set. To find the value of n, use the function COUNT(N).”?
 * (7) Examples, first two examples. Insert “the” before “harmonic mean”. The values in the Returns column are incorrect for both examples.
 * (8) Examples, third example. Insert “a” before “negative”.

--Stevefanning (talk) 2020-10-23T21:09:42 (UTC)

Ronnie
all points addressed.

--Ronnie rg8888 (talk) 2020-11-15T21:02:48 (UTC)