BINOMDIST's fourth argument should be logical

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Minor
    • ODF 1.2
    • Affects Version/s: None
    • Component/s: OpenFormula
    • None
    • 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).
    • 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).

      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

            Assignee:
            Andreas Guelzow (Inactive)
            Reporter:
            Andreas Guelzow (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: