W.Donkers at dci-electronics.nl
Wed Jul 26 10:05:43 UTC 2017
I'm looking at bug 109096.
The problem here is that ODFF1.2 does not have constraints for the number values and neither specifies a complete result description.
Geometric mean is defined as n-root( a1 * a2 * ... * an). This applies for n positive values a#.
This is awkward to compute as overflow is lurking in case of large values a and a large number n.
An alternative computation is given in ODFF, but the case of any value a# being 0 is not mentioned (result is then 0).
Any a# with value is a geometrically valid situation, unlike negative values which do not have any geometric meaning AFAIK.
I would propose an amendment of ODFF1.2 for GEOMEAN:
Constraints: numbers >= 0
Semantics: addition of Returns zero when one or more numbers have value 0.
What's your opinion?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the LibreOffice