The BINOM.DIST.RANGE Function[1] is categorized under Excel 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, for example, the three bestselling products from a range of products manufactured by a company.
The BINOM.DIST.RANGE function was introduced in MS Excel 2013 and hence is unavailable in earlier versions.
The BINOM.DIST.RANGE function uses the following arguments:
Trials (required argument) – This is the number of independent trials. It must be greater than or equal to 0.
Probability_s (required argument) – This is the probability of success in each trial. It should be greater than or equal to 0 and less than or equal to 1.
Number_s (required argument) – This 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 the number of trials.
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 the number of trials.
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 CFI resources:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.