OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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

    [ 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?

> -----------
>                 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 
> *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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]