Statistical Excel 2013 ◉ 14 views

=BINOM.DIST.RANGE()

Returns the probability of a trial result using a binomial distribution.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016

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

Hover argument names in the table for details.

Output typeNumber

Popularity8 / 100

VolatileNo

Dynamic ArrayNo

📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas

⬇ Download Sample Workbook

A dedicated .xlsx for =BINOM.DIST.RANGE() with Persian sample data & live formulas — open in Excel and practice.

Sheet “Sample” — data table + formula in place
Sheet “Guide” — syntax, arguments & tips from this page
Instant & secure (token + rate limit)

📥 Download BINOM.DIST.RANGE.xlsx — Coming soon ~ 8–12 KB · No macros

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

Start quiz →

◧ Arguments

Argument	Type	Required	Description
`trials`	Number	Required	The number of independent trials. Must be greater than or equal to 0.
`probability_s`	Number	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`	Number	Required	The number of successes in trials. Must be greater than or equal to 0 and less than or equal to Trials.
`number_s2`	Number	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.

▣ Examples

توزیع دوجمله‌ای بر اساس احتمال ۴۸ موفقیت در ۶۰ آزمایش با احتمال موفقیت ۷۵ درصد (۰٫۰۸۴ یا ۸٫۴ درصد). =BINOM.DIST.RANGE(60,0.75,48)

توزیع دوجمله‌ای بر اساس احتمال بین ۴۵ تا ۵۰ موفقیت (شامل هر دو) در ۶۰ آزمایش با احتمال موفقیت ۷۵ درصد (۰٫۵۲۴ یا ۵۲٫۴ درصد). =BINOM.DIST.RANGE(60,0.75,45,50)

✦ Tips

The following equation is used:
In the equation above, N is Trials, p is Probability_s, s is Number_s, s2 is Number_s2, and k is the iteration variable.
Numeric arguments are truncated to integers.

⚠ Common Errors

#NUM! If any arguments are outside of their constraints, BINOM.DIST.RANGE returns the #NUM! error value.

Fix: Correct the input value

#VALUE! If any arguments are non-numeric values, BINOM.DIST.RANGE returns the #VALUE! error value.

Fix: همه آرگومان‌ها را بررسی کنید و مطمئن شوید عدد هستند؛ موارد متنی را اصلاح کنید.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

=BINOM.DIST.RANGE() ☆