Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

BINOMDIST Function in Excel

In this post you’ll learn about BINOMDIST Function, its syntax and the way of using BINOMDIST Function in excel spreadsheet.

BINOMDIST

BINOMDIST Function refers to the calculation of probability of drawing a certain number of trial, with replacement of draws.

What is BINOMDIST Function?

BINOMDIST Function is a statistical function, it can be used as a Worksheet function (WS) in Excel. The Excel BINOMDIST Function returns and calculates the individual term binomial distribution probability.

You can use BINOMDIST to calculate probability that an event will occurs a certain number of times in a given number of trials. BINOMDIST Function used to return the probability as a decimal numbers between 0 and 1.

The BINOMDIST Function is also classified into one category as Compatibility Function which is replaced by BINOM.DIST Function.

Binary data occurs when observation can be placed into two categories.

Example:

When tossing a coin, the result can only be Head or tail. Or

When rolling a die, the result will be 6 or not 6 

Syntax

=BINOMDIST (number_success(s), trials, probability_success(s), cumulative)
Arguments:
  • = – built-in function.
  • number_success(s) – (required) the number of successes.
  • trials – (required) the number of independent trials.
  • Probability_success(s) – (required) the probability of success on each trial.
  • Cumulative – A logical value determines the function.

                         TRUE – cumulative distribution function.

                    FALSE – probability mass function.

Note:

  • number_success(s) and trials always must be integers, otherwise it will truncate into an integers.
  • #VALUE! Error value – If number_success(s), trials and probability_success(s) is a non-numeric value.
  • If number_s<0 or number_s>trials, BINOMDIST returns the #NUM! Error value.
  • If probability_s<0 or probability_s>1, BINOMDIST returns the #NUM! Error value.
  • If x= number_s, n= trials, and p= probability_s, then binomial probability mass function is,

If x= number_s, n= trials, and p= probability_s, then the cumulative binomial distribution is,

How to use BINOM.DIST function in Excel?

BINOMDIST Function is used to get the Binomial distribution probability.

Example:

You can see the results of rolling of die, getting either 6 or not by using BINOMDIST Function in Excel spreadsheet.

STEP 1:

Open the workbook in your Microsoft Excel.

STEP 2:

Enter the data in the workbook.

How to use BINOM.DIST function in Excel?

You can calculate the probability of rolling a six with a die.

STEP 3:

In the new cell, give the formula of the function or the syntax . Always start with ‘ =’ for every functions, BINOMDIST function name, followed by the open parenthesis, the arguments of the syntax.

How to use BINOM.DIST function in Excel?
STEP 4:

A die has six sides, the probability of rolling one six is 1/6.

How to use BINOM.DIST function in Excel?

number_s in rolling a six with a die is 1.

STEP 5:

Next step is the number of trials.

How to use BINOM.DIST function in Excel?

You can consider the probability of rolling 6 in a die as 10 trials. The trials are 10.

STEP 6:

Next is probability of success.

How to use BINOM.DIST function in Excel?

The probability of rolling 6 in 10 trials is about 32%. The probability_s is 32%.

STEP 7:

Next is cumulative argument.

How to use BINOM.DIST function in Excel?

The cumulative argument set as TRUE. This causes BINOMDIST to calculate the probability that there are “at most ” X success in a given number of trials.

STEP 8:

Press Enter, to get the results.

How to use BINOM.DIST function in Excel?