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)