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