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-2246) PROB: check andspecify details

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

Andreas Guelzow  commented on OFFICE-2246:

I believe that PROB is supposed to calculate the "probability of an interval for a discrete (and finite) probability distribution". In that case the DATA should not required to be ordered nor sequential nor integers (but of course they need to be numerical).
Start and End of course need to be numbers but there should be no requirement on any specific relationship to Data.
If End < Start then the probability should be 0, and if End is omitted it defaults to Start.

If Count(Data) != Count(Probability) we have  a failure to satisfy a constraint and we have defined elsewhere what should happen then.

I believe the current draft is complete, The absence of any further requirements is sufficient, ie. if it doesn't say that something need to be ordered then it doesn't need to be ordered.)

> PROB: check and specify details
> -------------------------------
>                 Key: OFFICE-2246
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2246
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Sub-task
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eike Rathke
>             Fix For: ODF 1.2
> Broken out from OFFICE-1170
> *This needs to specify if Data must be ordered or not (unordered?).
> *It would also be better to be clear about whether Data must be sequential (is 1, 2, 3, 5 (missing 4) OK?) and/or integer (is 1, 2.5, 3,4 OK?).
> *It would also be better to be clear about whether Start and End need to exist within Data (no?) and also whether they can be higher/lower than the max/min values in Data (yes?)
> * It would also be better to be clear about whether Start can be higher than End. Although they're defined as lower/upper bounds, is 'Start>End' an error, or valid with a probability of 0 returned?
> * This needs to specify how the result is calculated if End is omitted and Start is not present in Data (Calc returns 0).
> * This needs to specify the type of error returned - eg #N/A if Data Probability are different lengths. This is important because #N/A is a specific (testable) type of error.

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]