Talk:Documentation/Calc Functions/HARMEAN

From The Document Foundation Wiki
Jump to: navigation, search

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)


all points addressed.

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