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

# office message

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

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

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Mon, 26 Apr 2010 20:36:24 -0400 (EDT)

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