|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Excel > Functions > Statistical > BINOMDIST |
BINOMDIST(number_s, trials, probability_s, cumulative) |
| Returns the individual term binomial distribution probability. |
| number_s | The number of successes out of the "trials". | |
| trials | The number of independent trials. | |
| probability_s | The probability of success on each trial. | |
| cumulative | True or False to specify the form of the function. |
| REMARKS |
| The "number_s" and "trials" are truncated to integers. | ||
| If "number_s" is not numeric, then #VALUE! is returned. | ||
| If "cumulative" = True, it returns the cumulative distribution function, which is the probability that there are at most "number_s" successes. | ||
| If "cumulative" = False, it returns the probability mass function, which is the probability that there are "number_s" successes. | ||
| 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. | ||
| This function should be used when you have a fixed number of trials and the outcome of any trial can only be success or failure. | ||
| This function should be used when all the trials are independent and when the probability of success is constant throughout the experiment. | ||
| The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (827459). |
| EXAMPLES |
|
| Functions - B | Index - B | Office Online 2003 | Office Online 2007 |
| Copyright © 2010 Better Solutions Limited. All Rights Reserved. | Top |