Jak używać funkcji BINOM.DIST w Excelu
Polskie | Angielski |
---|---|
ROZKŁ.DWUM | BINOM.DIST |
Introduction to the Binomial Distribution
The ROZKŁ.DWUM function in MS Excel and its equivalent, the BINOM.DIST function in Google Sheets, are used to calculate the probability of successes in a series of Bernoulli trials, i.e., situations where each trial can result in either success or failure, with the probability of success remaining constant throughout the trials.
Function Syntax
The syntax for the ROZKŁ.DWUM function in Excel and BINOM.DIST in Google Sheets is as follows:
=ROZKŁ.DWUM(number_of_successes, number_of_trials, success_prob, cumulative)
- number_of_successes – The observed number of successes.
- number_of_trials – The total number of trials.
- success_prob – The probability of success in each trial.
- cumulative – A logical value; if TRUE, the function returns the cumulative probability (from 0 to number_of_successes); if FALSE, it returns the probability of achieving exactly number_of_successes.
Usage Examples
Formula | Description | Value |
---|---|---|
=ROZKŁ.DWUM(5, 10, 0.5, FALSE) |
Probability of exactly 5 successes in 10 trials with P(success) = 0.5 | 0.246 |
=BINOM.DIST(5, 10, 0.5, TRUE) |
Cumulative probability of achieving no more than 5 successes in 10 trials in Google Sheets | 0.623 |
Practical Scenarios
Here are several practical applications of the ROZKŁ.DWUM/BINOM.DIST functions:
Scenario 1: Quality Control in Production
Suppose we have a production line with a 5% defect rate. We want to calculate the probability of exactly two defective products in a batch of 20 items.
=ROZKŁ.DWUM(2, 20, 0.05, FALSE)
This formula returns the probability that precisely two out of twenty products will be defective, useful for assessing risk and planning quality control measures.
Scenario 2: Consumer Survey
We conducted a survey among 150 consumers, each of whom had a 30% chance of giving an affirmative answer. We want to find out the probability of receiving at least 50 confirmations.
=1 - ROZKŁ.DWUM(49, 150, 0.3, TRUE)
By subtracting the cumulative probability of achieving at most 49 successes from 1, we calculate the probability of obtaining at least 50 affirmative responses. This analysis is useful for evaluating consumer reactions to a new product or service.
Więcej informacji: https://support.microsoft.com/pl-pl/office/rozkł-dwum-funkcja-c5ae37b6-f39c-4be2-94c2-509a1480770c