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-1170) Public Comment: Re:[office-comment] ODFF: list of suggestions

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

Andreas Guelzow  commented on OFFICE-1170:

I assume that
> *Formulae: - I suspect that the integral may need to be from -infinity=20
> 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=20
> 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=20
> defined in terms of NORMDIST or NORMSDIST which is the simplest.
refers to LOGNORMDIST.

Clearly the integral has to start at 0 (the integrand isn't even defined for negative t). Of course there are lots of equivalent versions for that formula (one could use erf tohide the integral if desired), but we definitely should _not_ define this in terms of other OpenFormula functions ERF, LN, SQRT, NORMDIST or NORMSDIST. 

> Public Comment: Re: [office-comment] ODFF: list of suggestions
> --------------------------------------------------------------
>                 Key: OFFICE-1170
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1170
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Robert Weir 
>            Assignee: Eike Rathke
>            Priority: Blocker
>             Fix For: ODF 1.2
> Copied from office-comment list
> Original author: Eike Rathke <erack@sun.com> 
> Original date: 21 Dec 2008 20:54:35 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200812/msg00029.html

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]