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 +0000
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]
