https://bugs.freedesktop.org/show_bug.cgi?id=65086
Priority: medium
Bug ID: 65086
Assignee: [email protected]
Summary: STDEVP() returns wrong values
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.3.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 79906
--> https://bugs.freedesktop.org/attachment.cgi?id=79906&action=edit
Sample spreadsheet
Hi,
How to reproduce:
* Download attachment
or:
* 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;)
* Enter
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.
Kind regards,
Joren
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
