[OASIS Issue Tracker] Created: (OFFICE-2647) LOGNORMDIST

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

LOGNORMDIST
-----------

                 Key: OFFICE-2647
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2647
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Sub-task
          Components: OpenFormula
    Affects Versions: ODF 1.2 Part 2 CD 2, ODF 1.0 Errata CD 5, ODF 1.2 Part 1 CD 5, ODF 1.2 Part 2 CD 3, ODF-Next, Task
            Reporter: Robert Weir 


LOGNORMDIST
*Syntax: "NORMDIST " should read "LOGNORMDIST"
*Formulae: - I suspect that the integral may need to be from -infinity 
not 0 for the cumulative dist function (as with NORMDIST). I can't find 
this formula on the net - normally it seems to be quoted as 
1/2+1/2*ERF((LN(x)-u)/(s*SQRT(2))) - which does seem to produce the same 
results, and may be preferable if it is standard practice. Or could be 
defined in terms of NORMDIST or NORMSDIST which is the simplest.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira