[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User oc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from o...@openoffice.org Wed Sep 9 14:52:01 + 2009 --- verified in internal build cws_odff06 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User er changed the following: What|Old value |New value Assigned to|er|oc --- Additional comments from e...@openoffice.org Thu Sep 3 20:05:58 + 2009 --- Reassigning to QA for verification. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User er changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Subcomponent|code |programming --- Additional comments from e...@openoffice.org Wed Apr 29 22:40:18 + 2009 --- In cws odff06: revision 271396 sc/source/core/tool/interpr3.cxx I'm impressed :-) Thanks again! Btw, just changed bool kum to bool bCumulative and used GetBool() instead of GetDouble() for the argument and adapted the condition from (kum == 0.0) to (!bCumulative). - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 This issue depends on issue 100119, which changed state: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User er changed the following: What|Old value |New value Target milestone|OOo 3.x |OOo 3.2 --- Additional comments from e...@openoffice.org Wed Apr 22 09:32:47 + 2009 --- Thank you! Scheduling for inclusion in CWS odff06. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 --- Additional comments from reg...@openoffice.org Wed Apr 22 09:04:45 + 2009 --- Created an attachment (id=61725) Comparison with Excel and Gnumeric; example with large and with very large lambda - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 --- Additional comments from reg...@openoffice.org Tue Apr 21 20:23:11 + 2009 --- Created an attachment (id=61713) Avoid overflow and underflow in POISSON - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User regina changed the following: What|Old value |New value Issue type|DEFECT|PATCH --- Additional comments from reg...@openoffice.org Tue Apr 21 20:21:42 + 2009 --- The problems in POISSON have two reasons: The implementation calculated the factorial in the formula as separate sub-term, which will overflow for large x. It calculated exp(-lambda), which will underflow for large lambda. The second reason was not only in the cumulative part but in the mass part too. (The other problem in the mass part had been fixed in issue 26022 already.) To avoid the overflow in factorial, I change the calculation order. To avoid the underflow in exp(-lambda), I made a case distinction. For large lambda a different method is used. That is not as accurate as the iteration in the case of small lambda, but it still gives 12-13 significant digits. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User erack changed the following: What|Old value |New value IssuesThisDependsOn|97091 |97091,100119 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 --- Additional comments from reg...@openoffice.org Wed Mar 25 13:14:15 + 2009 --- The improvement of the accuracy of NORMSDIST is included in the patch in issue 100119. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 This issue depends on issue 97091, which changed state: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User er changed the following: What|Old value |New value IssuesThisDependsOn| |97091 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User regina changed the following: What|Old value |New value CC|'delorea' |'delorea,regina' --- Additional comments from [EMAIL PROTECTED] Wed Dec 10 10:35:11 + 2008 --- The wrong results in NORMSDIST are due to cancellation for small negative values, where gauss() is near -0.5 The problem can be solved in two ways: (1) Use NORMSDIST(x)= 0.5*ERFC(-x/SQRT(2)). Unfortunaly ERFC is only an addin function, see my issue 97091. (2) Use NORMSDIST(x) = 0.5+0.5*GetLowRegIGamma(0.5,0.5*x*x) for x>=0 = 0.5*GetUpRegIGamma(0.5,0.5*x*x) for x<0 I would prefer the solution (1), because GetLowRegIGamma and GetUpRegIGamma use iterations which might be slow in some cases and erfc uses a short polynomial. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User er changed the following: What|Old value |New value Target milestone|OOo 3.1 |OOo 3.x - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 --- Additional comments from [EMAIL PROTECTED] Tue Jul 1 16:52:35 + 2008 --- *** Issue 91269 has been marked as a duplicate of this issue. *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 --- Additional comments from [EMAIL PROTECTED] Tue Jul 1 16:51:52 + 2008 --- *** Issue 91269 has been marked as a duplicate of this issue. *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User er changed the following: What|Old value |New value Target milestone|OOo 3.0 |OOo 3.1 --- Additional comments from [EMAIL PROTECTED] Fri May 30 15:04:58 + 2008 --- Propably not doable in time frame for 3.0, retargeting to 3.1 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 69069] NORMSDIST, POISSON statist ical functions are not accurate
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69069 User er changed the following: What|Old value |New value OtherIssuesDependingOnTh| |18704 is| | Summary|Statistical Functions are |NORMSDIST, POISSON statist |not Accurate |ical functions are not ac | |curate --- Additional comments from [EMAIL PROTECTED] Wed Jul 25 10:42:00 + 2007 --- Sorry for "dependency spam" when changing from "depends on" to "blocks" issue 18704. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]