Created attachment 79906 [details]
How to reproduce:
* Download attachment
* Open Calc
* Enter the following numbers from B1 to B8:
2, 4, 4, 4, 5, 5, 7, 9 (by example of https://en.wikipedia.org/wiki/Stdev#Basic_examples)
* Select A1
* formula in A1: =STDEVP(B1;B2;B3;B4;B5;B6;B7;B8;)
Result: 2,454524<bla bla bla>
Expected result: 2 (see https://en.wikipedia.org/wiki/Stdev#Basic_examples)
Doing the same in Excel for Mac result in a 2 (which is correct).
Also other Standard Deviation functions are affected.
Tested on LO 126.96.36.199 (Win7 32bit)
=STDEVP(B1;B2;B3;B4;B5;B6;B7;B8;) -> 2,4545247
=STDEVP(B1;B2;B3;B4;B5;B6;B7;B8) -> 2
I think ; followed with no value should trigger error message & suggest correction
Empty argument is considered as 0.
Not specific to statistical functions.
With 1 in A1, 2 in A2,
=AVERAGE(A1;A2;) gives result 1
Thanks for all replies and testing! You both are right! Deleting the trailing ';' fix this, I agree a warning/suggestion would be very welcome in this cases.
Therefore I'll change this bug to an enhancement request.