How to use BINOM.DIST.RANGE Function in Excel

The Excel Binom.Dist.Range function returns the Binomial Distribution probability for the number of successes from a specified number of trials falling into a specified range.

Syntax:= BINOM.DIST.RANGE(trials,probability_s,number_s,[number_s2])

The BINOM.DIST.RANGE function syntax has the following arguments:

  • Trials    Required. The number of independent trials. Must be greater than or equal to 0.
  • Probability_s    Required. The probability of success in each trial. Must be greater than or equal to 0 and less than or equal to 1.
  • Number_s    Required. The number of successes in trials. Must be greater than or equal to 0 and less than or equal to Trials.
  • Number_s2    Optional. If provided, returns the probability that the number of successful trials will fall between Number_s and number_s2. Must be greater than or equal to Number_s and less than or equal to Trials.

Example: Let’s look at some Excel BINOM.DIST.RANGE function examples and explore how to use the BINOM.DIST.RANGE function as a worksheet function in Microsoft Excel:

BINOM.DIST .RANGE Function - How to use BINOM.DIST.RANGE Function in Excel

Syntax:  =BINOM.DIST.RANGE(B1,B2,B3)

Result: 0.000548825

BINOM.DIST .RANGE Function in Excel 1 - How to use BINOM.DIST.RANGE Function in Excel

Based on the Excel spreadsheet above, the following BINOM.DIST.RANGE examples would return:

Syntax: =BINOM.DIST.RANGE(B1,B2,B4)
Result: 0.081675913

Syntax: =BINOM.DIST.RANGE(B1,B2,B5)
Result: 0.008006662

Syntax: =BINOM.DIST.RANGE(B1,B2,B3,B4)
Result: 0.837527794

Syntax: =BINOM.DIST.RANGE(B1,B2,B4,B5)
Result: 0.237912905

Syntax: =BINOM.DIST.RANGE(B1,B2,B6,B7)
Result: 5.002E-05

Note:

  1. The function will truncate all numerical values to integer.
  2. #VALUE! error – Occurs when any of the arguments provided is non-numeric.
  3. #NUM! error – Occurs when:
    1. The given probability is less than zero or greater than 1.
    2. The given number_s is less than zero or greater than the trials argument.
    3. The given number_s2 is less than zero or greater than trials or less than number_s.
  4. The following equation is used:
    BINOM.DIST .RANGE Function in Excel - How to use BINOM.DIST.RANGE Function in Excel
READ:  How to use FORECAST.ETS.STAT Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *