[OASIS Issue Tracker] Issue Comment Edited: (OFFICE-1206) PublicComment: [office-formula] domain for x in HYPGEOMDIST(x;n;M;N)

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

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

Andreas Guelzow  edited comment on OFFICE-1206 at 8/10/09 11:10 AM:
--------------------------------------------------------------------

As suggested by the original author the constraints could be changed to:

Constraints: x,n,M,N must be integers and are truncated if non-integer. Further, x<=n, n <=N,
M<=N with x,n,M,N >=0.

In the definition we are using the mathematical binomial coefficient (ie. binom(a,b) is the number of b-subsets  possible out of a set of a distinct items)  rather than the BINOM function, so this definition extends to that enlarged range for x since binom(a,b) is 0 if b > a.

Note that contrary to the original author this is not what Gnumeric does anymore, so if we want to encode what GNuemric Excel and OOo in fact are doing we should keep the original constraints. 


      was (Author: aguelzow):
    As suggested by the original author the constraints should be cahnged to:

Constraints: x,n,M,N must be integers and are truncated if non-integer. Further, x<=n,
M<=N with x,n,M,N >=0.

In the definition we are using the mathematical binomial coefficient (ie. binom(a,b) is the number of b-subsets  possible out of a set of a distinct items)  rather than the BINOM function, so this definition extends to that enlarged range for x since binom(a,b) is 0 if b > a.

  
> Public Comment: [office-formula] domain for x in HYPGEOMDIST(x;n;M;N)
> ---------------------------------------------------------------------
>
>                 Key: OFFICE-1206
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1206
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Robert Weir 
>             Fix For: ODF 1.2
>
>
> Copied from office-comment list
> Original author: Regina Henschel <rb.henschel@t-online.de> 
> Original date: 15 Feb 2009 13:02:00 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200902/msg00007.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