# BINOMDIST's fourth argument should be logical

XMLWordPrintable

#### Details

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: None
• Fix Version/s:
• Component/s:
• 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

#### People

• Assignee:
Andreas Guelzow (Inactive)
Reporter:
Andreas Guelzow (Inactive)
• Watchers:
0 Start watching this issue

#### Dates

• Created:
Updated:
Resolved: