Buzz
The BINOMDIST function calculates the probability values of binomial distribution for trials based on input data such as the number of successful trials, the total number of independent trials performed, and the probability of success for each trial. The function can yield different results depending on a specified logical value.
This tutorial is part of the advanced Excel learning program developed by Mytour.
BINOMDIST Function in Excel
Illustrated examples on how to use BINOMDIST function in Excel
Syntax: BINOMDIST(number_s,trials,probability_s,cumulative)
Consider an Example:
Input your real values into an Excel spreadsheet corresponding to the function parameters in Excel cells. In this example, we calculate with parameter values: Number of successful trials is 8, Number of independent trials is 12, Probability of success per trial is 0.75.
Enter the formula at cell C10. And the computed result of the function received when the logical value is TRUE is 0.351221383.
Enter the formula at cell D10 for the remaining case, when the logical value is FALSE is 0.193577707.
So, now you know how to use the BINOMDIST function in Excel. When performing calculations with this function, you need to note that the input data for Number_s and Trials must be integers and Probability_s must belong to the value range from 0 to 1. The BINOMDIST function can be applied in Office 2013, Office 2010, Office 2007, and Office 2003 versions.
