|
Microsoft Office Development and Consultancy |
| Home | | | Excel | | | VBA | | | C# | | | Finance | | | Tools | | | Newsletter | | | Feedback | | | Contact |
| Excel > Functions > Statistical > BINOMDIST |
BINOMDIST(number_s, trials, probability_s, cumulative) |
| Returns the probability of getting 'less than' or 'equal to' to a particular value in a binomial distribution. |
| number_s | The number of successes out of the "trials". | |
| trials | The number of independent trials. | |
| probability_s | The probability of a success on each trial. | |
| cumulative | The type of function to use: True = cumulative probability function (less than) False = probability mass function (equal to) |
| REMARKS |
| BINOM.DIST was added in 2010 to replace this function. | ||
| The binomial distribution is a discrete distribution. | ||
| If "cumulative" = True, then the area under the curve to the left of "x" is returned. This uses the cumulative probability function. | ||
| If "cumulative" = False, then the height of the bell shaped curve at "x" is returned. This uses the probability mass function. | ||
| The "number_s" and "trials" are truncated to integers. | ||
| If "number_s" is not numeric, then #VALUE! is returned. | ||
| If "number_s" < 0, then #NUM! is returned. | ||
| If "number_s" > "trials", then #NUM! is returned. | ||
| If "trials" is not numeric, then #VALUE! is returned. | ||
| If "probability_s" < 0, then #NUM! is returned. | ||
| If "probability_s" > 1, then #NUM! is returned. | ||
| If "probability_s" is not numeric, then #VALUE! is returned. | ||
| In Excel 2010 the accuracy of this function was improved. | ||
| In Excel 2003 the accuracy of this function was improved Knowledge Base Article (827459). |
| EXAMPLES |
|
| Functions - B | Index - B | Office Online 2010 | 2007 | 2003 |
| © 2013 Better Solutions Limited. All Rights Reserved. | Top | 03-Jan-2013 |