Afrikaans
Akan
Albanian
Amharic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Ewe
Faroese
Filipino
Finnish
French
Frisian
Ga
Galician
Georgian
German
Greek
Guarani
Gujarati
Haitian Creole
Hausa
Hawaiian
Hebrew
Hindi
Hmong
Hungarian
Icelandic
Igbo
Indonesian
Interlingua
Irish
Italian
Japanese
Javanese
Kannada
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kurdish (Soranรฎ)
Kyrgyz
Laothian
Latin
Latvian
Lingala
Lithuanian
Lozi
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Malayalam
Maltese
Maori
Marathi
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Nigerian Pidgin
Northern Sotho
Norwegian
Norwegian (Nynorsk)
Occitan
Oriya
Oromo
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Punjabi
Quechua
Romanian
Romansh
Runyakitara
Russian
Samoan
Scots Gaelic
Serbian
Serbo-Croatian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Spanish (Latin American)
Sundanese
Swahili
Swedish
Tajik
Tamil
Tatar
Telugu
Thai
Tigrinya
Tonga
Tshiluba
Tumbuka
Turkish
Turkmen
Twi
Uighur
Ukrainian
Urdu
Uzbek
Vietnamese
Welsh
Wolof
Xhosa
Yiddish
Yoruba
Zulu
- [Instructor] Another data distribution
is called the binomial distribution.
And that deals with trials
where there are only two possible outcomes, true or false.
A customer might either sign up for,
or not sign up for your company's mailing list for example.
In this movie,
I will show you how to calculate the probabilities
for outcomes described by the binomial distribution.
So we will need our chance of success,
and the number of trials,
that is the number of customers who appear.
And we can use those calculations to graph the likelihood
of a specific number of customers signing up.
With that introduction, I will switch over to Excel.
My Excel sample files is 04 05 binomial,
and you can find it in the chapter four folder
of the exercise files collection.
In this workbook, I have a worksheet with a graph
that will show the sign of percentage
based on calculations we make in the table on the left.
We have the two pieces of information we need in column B.
So in B1, which is already selected,
I have the probability of success,
and we're assuming that a customer will be 35% likely
to sign up for our company's mailing list,
if we present it to them,
and we are going to work with 20 customers at a time.
And from there, we can evaluate our data.
To create our formula, I will click and cell B5,
and this is an Excel table, so when I enter this formula
in the first row of this column,
the formula should be copied down.
So I will type in the equals sign,
and the function we'll use is binom.dist.
So B-I-N-O-M dot D-I-S-T.
The number of successes is in cell A5,
so the first calculation will ask about the probability
of getting zero successes, in other words, no one signs up.
And a comma, then the number of trials,
and that is in cell B2.
I don't want that reference to change,
so I'll press F4, that's command T on the Mac, that comma.
Probability of success, that's in B1 so I'll click there,
and again, F4, comma, and a question of whether we want
the probability of getting that value or less,
or the specific value exactly.
In this case, I want the specific value,
so I will highlight false for the probability mass function,
also called the point probability.
Press tab, right parenthesis and enter.
And the formula didn't copy down,
but if I click the action button that appears,
that's the auto correct options button,
and then click overwrite all cells in this column
with this formula.
Then I get the updated calculations,
and the chart that you see on the right.
Looking at the data, based on 35% probability
of an individual signing up,
and 20 as the number of customers we approach,
we can see that the most likely outcome is seven.
And that makes sense, because 0.35 times 20 is seven.
So it's very unlikely that no one will sign up.
And most of the time it looks like we will have between,
say about four and 11 individuals signing up.
And again, it appears that our most common value
will be seven.
If you want to determine the probability
of a specific number of successes or less occurring,
you can change the last argument from false to true.
So I will double click and cell B5,
which contains my first formula.
Backspace far enough so I get true,
the cumulative distribution function.
Press tab to accept it, enter.
And this time the formulas in the column did update.
So as you can see, the probability
of getting five individuals or less,
or fewer, I guess, is about 21%,
and then six or fewer is about 40%, 41 in this case.
60% for seven or less, and that continues on up to 20.
And you can see that there is not much of a change
in the probability between getting 14, so that's 96.97%,
and 15, which is 99.995%.
So it is very unlikely that we will have
anything more than about 10 people showing up,
or signing up in a particular hour.
Analyzing data using the binomial distribution
lets you determine the likelihood
of achieving certain results,
when faced with a series of yes or no trials.
If you're not hitting your targets for manual signup,
or sales opportunities, you should consider
whether your approach needs to be changed,
or if your expected success rate is too high.
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.