https://bugs.freedesktop.org/show_bug.cgi?id=51083
Bug #: 51083
Summary: Mathematical error in formula
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.4 release
Platform: All
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: marot.jacq...@gmail.com
Created attachment 63034
--> https://bugs.freedesktop.org/attachment.cgi?id=63034
experimental spreadsheet to find error with formula BINOMDIST = (391, 462,
0.8, TRUE ())
I find abberrants results in open-office-calc on the binomial distribution
B(n,p). Only certain values โโof n and p in a timely manner produce random
errors.
This calculation.
BINOMDIST = (391, 462, 0.8, TRUE ())
should give the probability of obtaining x=391 success on n=462 random
experiment with two issues and success probability p = 0.8. The real
calculation in various formal-calculator Texas or Casio gives 0.995603391,
libre-office gives 0,826 .... (Serious difference!)
While a formal calculator gives a probability p with 1-p< 10 ^ {-30} as soon as
x>420, libre-office gives results lower than 0.830 for all n <462.
It's only for x = 462 that we found the expected result: 1.
Most troubling is that the calculations of libre-office become again
consistent for n <> 462 and p = 0.801 and p = 0799. I have noticed this
inconsistency as rare as integer values โโn = 462, accidentally encountered by
testing the binomial distribution under libre-office with this spreadsheet
attached (error in cell J7 ).
P, S,: functionality on the same sheet in excel gives good results!?
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
