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] Created: (OFFICE-2647) 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 

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