Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Count rows that contain specific values in Excel
  • How to use Excel INDIRECT Function
  • How to get last row in numeric data in Excel
  • How to get relative row numbers in a range in Excel
  • How to use Excel OFFSET function

Data Analysis Examples

  • Conflicting Multiple Conditional Formatting Rules in Excel
  • How to calculate average last N values in a table in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to create a Histogram in Excel
  • How To Create Frequency Distribution in Excel

Data Validation Examples

  • Prevent invalid data entering in specific cells
  • Excel Data validation date in next 30 days
  • Excel Data validation date in specific year
  • Excel Data validation allow weekday only
  • Excel Data validation with conditional list

BINOM.DIST.RANGE function: Description, Usage, Syntax, Examples and Explanation

by

What is BINOM.DIST.RANGE function in Excel?

BINOM.DIST.RANGE function is one of Statistical functions in Microsoft Excel that returns the probability of a trial result using a binomial distribution.

Syntax of BINOM.DIST.RANGE function

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.

BINOM.DIST.RANGE formula explanation

  • If any arguments are outside of their constraints, BINOM.DIST.RANGE returns the #NUM! error value.
  • If any arguments are non-numeric values, BINOM.DIST.RANGE returns the #VALUE! error value.
  • The following equation is used:
    BINOM.DIST.RANGE equation
  • 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.

Example of BINOM.DIST.RANGE function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Formula Description Result
=BINOM.DIST.RANGE(60,0.75,48) Returns the binomial distribution based on the probability of 48 successes in 60 trials and a 75% probability of success (0.084, or 8.4%). 0.084
=BINOM.DIST.RANGE(60,0.75,45,50) Returns the binomial distribution based on the probability of between 45 and 50 successes (inclusive) in 60 trials and a 75% probability of success (0.524, or 52.4%). 0.524

Post navigation

Previous Post:

BINOM.INV function: Description, Usage, Syntax, Examples and Explanation

Next Post:

BINOM.DIST function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Join first and last name — Manipulating NAMES in Excel
  • How to Capitalize first letter in a sentence in Excel
  • Change Case: Uppercase, Lowercase, Propercase in Excel
  • Get last name from name with comma — Manipulating NAMES in Excel
  • How to count specific characters in a cell in Excel
  • Get last working day in month in Excel
  • How to get same date next year or previous year in Excel
  • Sum through n months in Excel
  • Convert Unix time stamp to Excel date
  • How to calculate future date say 6 months ahead in Excel
  • Compound Annual Growth Rate CAGR formula examples in Excel
  • COUPPCD function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate annuity for interest rate in excel
  • ACCRINT function: Description, Usage, Syntax, Examples and Explanation
  • TBILLEQ function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles