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

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

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18864#action_18864 ] 

Andreas Guelzow  commented on OFFICE-2647:
------------------------------------------

If we keep the definiiton in terms of the integral, then the integral should definitely start at 0. The integrand is undefined for negative t. The syntax in draft 25 already reads LOGNORMDIST. WHere are you seeing NORMDIST?

> 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