Türk | İngilizce |
---|---|
BİNOM.TERS | BINOM.INV |
The binomial distribution defines the probability distribution of the number of successes in a given number of trials with a specified probability of success in each trial. In Excel and Google Sheets, the BINOM.INV
function, or BİNOM.TERS
in Turkish, is used to calculate the likelihood of achieving a certain threshold number of successes or fewer.
Syntax and Examples
The general syntax for the BİNOM.TERS
function is as follows:
=BİNOM.TERS(trials, success_probability, alpha)
- trials – Specifies the number of trials and must be a positive integer.
- success_probability – Indicates the probability of success on each trial and must be a value between 0 and 1.
- alpha – Represents the desired cumulative distribution probability, which must also be between 0 and 1.
Example: On a production line, the probability of a product being flawlessly manufactured is 80%. If 10 products are produced, to estimate with 90% confidence the minimum number of products that will be flawless, you would use:
=BİNOM.TERS(10, 0.8, 0.9)
This function estimates that at least 8 out of 10 products will be flawless with 90% probability.
Practical Applications
Example Scenario 1
Your company is organizing a widespread contest where each participant has a 5% chance of winning. If 200 people participate, calculate the minimum success threshold to ensure that at least 15 participants win:
=BİNOM.TERS(200, 0.05, 0.95)
In this example, the function calculates that at least 15 winners is 95% likely to occur.
Example Scenario 2
In a school, there is a multiple-choice exam where each question has a 25% chance of being answered correctly by random guessing. If there are 20 students in a class, each taking a 40-question test, what cumulative probability is needed to guarantee that at least half the class, or at least 10 students, answer 15 or more questions correctly?
=BİNOM.TERS(40, 0.25, 0.5)
Here, the function calculates the minimum number of correct answers needed for a student to answer 15 or more out of 40 questions correctly, and for half the class to achieve this with a 50% probability.
Utilizing these functions can help you model scenarios with inherent uncertainties and make more informed predictions in your decision-making processes.
Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/bİnom-ters-işlevi-80a0370c-ada6-49b4-83e7-05a91ba77ac9