Microsoft KB Archive/100121: Difference between revisions
(importing KB archive) |
m (Text replacement - "<" to "<") |
||
(2 intermediate revisions by the same user not shown) | |||
Line 43: | Line 43: | ||
If cumulative is TRUE, then BINOMDIST() returns the cumulative distribution function, which is the probability that there are at most number_s successes; if FALSE, it returns the probability mass function, which is the probability that there are number_s successes. | If cumulative is TRUE, then BINOMDIST() returns the cumulative distribution function, which is the probability that there are at most number_s successes; if FALSE, it returns the probability mass function, which is the probability that there are number_s successes. | ||
If number_s | If number_s <0 or number_s> trials, BINOMDIST() returns #NUM. | ||
If probability_s | If probability_s <0 or probability_s> 1, BINOMDIST() returns #NUM. | ||
For example, in a population of software engineers, 9 out of 10 recommend 5.25-inch disks. What is the probability of choosing two engineers at random and finding that neither of them recommends 5.25-inch disks? | For example, in a population of software engineers, 9 out of 10 recommend 5.25-inch disks. What is the probability of choosing two engineers at random and finding that neither of them recommends 5.25-inch disks? | ||
Line 70: | Line 70: | ||
<br /> | <br /> | ||
<br /> | <br /> | ||
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED | THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. | ||
</blockquote> | </blockquote> | ||
<span>Last reviewed: September 12, 1996</span><br /> | <span>Last reviewed: September 12, 1996</span><br /> | ||
[[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /> | [[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /> | ||
|} | |} |
Latest revision as of 14:41, 20 July 2020
Microsoft Knowledge Base
Excel: Using the BINOMDIST() Function
Last reviewed: September 12, 1996
Article ID: Q100121
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
- Microsoft Excel for the Macintosh, version 4.0
SUMMARY
The BINOMDIST() function returns the individual term binomial distribution probability.
When you use the BINOMDIST function, you make the following three assumptions:
- The outcome of each trial is only success or failure. -and-
- The trials are independent. -and-
- The probability of success is constant throughout the experiment.
MORE INFORMATION
The following is the syntax for the BINOMDIST() function,
BINOMDIST(number_s,trials,probability_s,cumulative)
where:
NUMBER_S is the number of successes in trials TRIALS is the number of independent trials PROBABILITY_S is the probability of success on each trial CUMULATIVE is a logical value that determines the form of the function
If cumulative is TRUE, then BINOMDIST() returns the cumulative distribution function, which is the probability that there are at most number_s successes; if FALSE, it returns the probability mass function, which is the probability that there are number_s successes.
If number_s <0 or number_s> trials, BINOMDIST() returns #NUM.
If probability_s <0 or probability_s> 1, BINOMDIST() returns #NUM.
For example, in a population of software engineers, 9 out of 10 recommend 5.25-inch disks. What is the probability of choosing two engineers at random and finding that neither of them recommends 5.25-inch disks?
To calculate the following values in a BINOMDIST() function,
number_s = 0 trials = 2 probability_s = 0.9 cumulative = false
you would use the formula, BINOMDIST(0,2,0.9,false). This formula returns a result of 0.01 or 1%.
KBCategory: kbusage Last reviewed: September 12, 1996 |