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

[ http://tools.oasis-open.org/issues/browse/OFFICE-1206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andreas Guelzow  updated OFFICE-1206:
-------------------------------------

    Resolution: 
a) Change all occurrences of HYPERGEOMDIST to teh correct name HYPGEOMDIST. (Currently HYPERGEOMDIST occurs in the seealso of TDIST and WEIBULL)

b) Change the syntax of HYPGEOMDIST to  
       HYPGEOMDIST( Integer x ; Integer n ; Integer M ; Integer N [ ; Logical Cumulative = FALSE() ] )

c) Change the constraints to
     0 <= x <= n <= N, 0<= M<=N 

d) Add a note following the formulas that binom(x,y) = 0 for y > x (where "binom (x,y)" is written as x above y with round parentheses, as the corresponding terms are written inteh formula.)

      Priority: Blocker

Reformulating this essentially gives version B of the comment with the benefit of the simple formulas of version A. Also a hypergeometrically distributed random variable hasthe possible values 0 through n where some of these may have probability 0. 

> 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 
>            Assignee: Andreas Guelzow 
>            Priority: Blocker
>             Fix For: ODF 1.2
>
>
> Copied from office-comment list
> Original author: Regina Henschel <> 
> 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