Enrollment for the FMVA™ Certification Program is now OPEN!

BINOM.DIST.RANGE Function

Calculates the binomial distribution probability for a given number of successes

What is the BINOM.DIST.RANGE Function?

The BINOM.DIST.RANGE function is categorized under Statistical functions. It will calculate the binomial distribution probability for the number of successes from a specified number of trials falling into a specified range.

In financial analysis, the function can be useful in finding out the probability of the three bestselling products from a range of products by a company.

The BINOM.DIST.RANGE function was introduced in MS Excel 2013 and hence is unavailable in earlier versions.

 

Formula

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

 

The BINOM.DIST.RANGE function uses the following arguments:

  1. Trials (required argument) – It is the number of independent trials. It must be greater than or equal to 0.
  2. Probability_s (required argument) – It is the probability of success in each trial. It should be greater than or equal to 0 and less than or equal to 1.
  3. Number_s (required argument) – It is the number of successes in trials. It should be greater than or equal to 0. Also, it should be less than or equal to trials.
  4. Number_s2 (optional argument) – When provided, it will return the probability that the number of successful trials will fall between number_s and number_s2. It should be greater than or equal to number_s and less than or equal to trials.

To learn more, launch our free Excel crash course now!

 

How to use the BINOM.DIST.RANGE Function?

To understand the uses of the BINOM.DIST.RANGE function, let us consider an example:

 

Example

Suppose we are given the following data:

 

BINOM.DIST.RANGE Function

 

The formula for calculating binomial distribution is shown below:

 

BINOM.DIST.RANGE - Example 1

 

We get the result below:

 

BINOM.DIST.RANGE - Example 1a

 

Few notes about the BINOM.DIST.RANGE Function

  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.

 

Free Excel Course

Work your way toward becoming an expert financial analyst by checking our Free Excel Crash Course. Learn how to use Excel functions and create sophisticated financial analysis and financial modeling.

 

free Excel keyboard shortcuts course

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

Free Excel Tutorial

To master the art of Excel, check out CFI's FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.  

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!