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

[ http://tools.oasis-open.org/issues/browse/OFFICE-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Brauer updated OFFICE-2647:
-----------------------------------

    Affects Version/s:     (was: ODF 1.0 Errata CD 5)
                           (was: ODF 1.2 Part 1 CD 5)
                           (was: ODF 1.2 Part 2 CD 3)
                           (was: ODF-Next)
                           (was: Task)

> 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
>            Reporter: Robert Weir 
>            Assignee: Andreas Guelzow 
>             Fix For: ODF 1.2 Part 2 CD 2
>
>
> 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