math function AVERAGE slightly imprecise - from mathematical / decimal POV, gnumeric can do better
have the impression AVERAGE is calculated as '= ( operand1 [+ operand2 + operand3 ...] ) / count( operands )
' leading to ' 15.075000000000001 in 3rd test in statfuns.xls, rather than
'= sum( operand1 [, operand2 , operand3 ...] ) / count( operands )
' which would give the mathematically correct 15.075.
Could be first solution has better Excel compatibility??, ( Calc is clean ) ... But striving for mathematical accuracy in more complex functions is easier with correct basic blocks.
Pls. recheck carefully, can also be error(s) of whatever kind on my system.