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

Inne funkcje
Oblicza odchylenie standardowe na podstawie całej populacji
Oblicza odchylenie standardowe na podstawie całej populacji, z uwzględnieniem liczb, teksów i wartości logicznych
Szacuje odchylenie standardowe na podstawie próbki
Szacuje odchylenie standardowe na podstawie próbki, z uwzględnieniem liczb, tekstów i wartości logicznych
Zwraca błąd standardowy przewidzianej wartości y dla każdej wartości x w regresji
Zwraca funkcję skumulowanego rozkładu beta