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.
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:
Based on the Excel spreadsheet above, the following BINOM.DIST.RANGE examples would return:
- The function will truncate all numerical values to integer.
- #VALUE! error – Occurs when any of the arguments provided is non-numeric.
- #NUM! error – Occurs when:
- The given probability is less than zero or greater than 1.
- The given number_s is less than zero or greater than the trials argument.
- The given number_s2 is less than zero or greater than trials or less than number_s.
- The following equation is used: