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

Diğer fonksiyonlar
Bağımsız değişkenler listesinde kaç tane değer bulunduğunu sayar
Bağımsız değişkenler listesinde kaç tane sayı bulunduğunu sayar
Aralıktaki boş hücre sayısını hesaplar
Verilen birden çok ölçüte uyan bir aralık içindeki boş olmayan hücreleri sayar
Verilen ölçütlere uyan bir aralık içindeki boş olmayan hücreleri sayar
İki veri kümesi arasındaki bağlantı katsayısını verir
Doğrusal eğilim boyunca bir değer verir