BINOMDIST Excel Formula

Author Zaheer    Category Formulas     Tags ,

Excel Statistical Function allows the use to do specific calculations such determining the mean, median, and mode, probability tests, and statistical distribution. However, some of the Excel Statistical Functions are not pre-installed in older versions of Excel.

A BINOMDIST function is a Statistical Function in Excel that precedes the binomial distribution probability of a specific numeric value. The function also use in calculations with a specific number of trials, the success or failure of a trial, independent trial, and the constant possibility of success of an experiment.

The syntax of the BINOMDIST function is as =BINOMDIST (number_s, trials, probability_s, cumulative). The argument number_s refers to how many is the success in trials. The argument trials refer to the amount of autonomous trials in the formula. The probability_s argument is the possibility of success in every given trial. Cumulative argument is the value that you want the cumulative distribution or probability mass function will be calculated. The cumulative argument is true if the cumulative distribution is used and it is false if the probability mass function is used.

If the #VALUE! Error occurs it could be because the values of the number_s, trials, or probability_s arguments are non-numeric. The error #NUM! Error will occur if the given value of the argument number_s and the probability_s argument is lesser than zero or more than one.

To try the BINOMDIST function, open a blank Excel spreadsheet and on cell A2 input the value 6 which represents the number of success in many trial, in cell A3 input the value 10 which will be the value of the independent trials lastly, in cell A4 input the value 0.5 which will be the value for the possibility of success in every trial. Select a blank cell and input the formula which is =BINOMDIST (A2, A3, A4, FALSE) and the result will be 0.205078.

To switch viewing from the formula to its results, select the source cell and hit Ctrl+` (grave accent). Also, you can do this on the Formulas tab and on the Formula Auditing select the Show Formulas button.

Post comment