Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2159

BINOMDIST's fourth argument should be logical

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Change the fourth argument to: Logical Cumulative = TRUE()

      It would become:

      6.17.9 BINOMDIST
      Summary: Returns the binomial distribution.
      Syntax: BINOMDIST( Integer S ; Integer N ; Number P [; Logical Cumulative = TRUE()])
      Returns: Number
      Constraints: 0<=P<=1; 0<=S<=N
      Semantics: If Cumulative is FALSE(), this function returns the same result as B(N;P;S). If Cumulative is 1, it is equivalent to
      calling B(N;P;0;S).

      Show
      Change the fourth argument to: Logical Cumulative = TRUE() It would become: 6.17.9 BINOMDIST Summary: Returns the binomial distribution. Syntax: BINOMDIST( Integer S ; Integer N ; Number P [; Logical Cumulative = TRUE()] ) Returns: Number Constraints: 0<=P<=1; 0<=S<=N Semantics: If Cumulative is FALSE(), this function returns the same result as B(N;P;S). If Cumulative is 1, it is equivalent to calling B(N;P;0;S).
    • Resolution:
      Hide

      Changed the 4th argument from "Integer C" to "Logical Cumulative".
      In current implementations this parameter is not optional, it is required.

      Changed Constraints to
      0 <= P <= 1; 0 <= S <= N

      Changed Semantics to
      If Cumulative is FALSE(), this function returns the same result as B(N;P;S). If Cumulative is TRUE(), it is equivalent to calling B(N;P;0;S).

      Show
      Changed the 4th argument from "Integer C" to "Logical Cumulative". In current implementations this parameter is not optional, it is required. Changed Constraints to 0 <= P <= 1; 0 <= S <= N Changed Semantics to If Cumulative is FALSE(), this function returns the same result as B(N;P;S). If Cumulative is TRUE(), it is equivalent to calling B(N;P;0;S).

      Description

      The ...DIST functions typically have an argument that selects between the cumulative distribution and the mass or density function. That argument is typically Logical Cumulative = TRUE() (see for example CHISQDIST, EXPONDIST, FDIST,...)

      In the case of BINOMDIST it is currently Integer C

        Attachments

          Activity

            People

            • Assignee:
              aguelzow Andreas Guelzow
              Reporter:
              aguelzow Andreas Guelzow
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: