All language subtitles for 05 - Use the binomial distribution

af Afrikaans
ak Akan
sq Albanian
am Amharic
hy Armenian
az Azerbaijani
eu Basque
be Belarusian
bem Bemba
bn Bengali
bh Bihari
bs Bosnian
br Breton
bg Bulgarian
km Cambodian
ca Catalan
ceb Cebuano
chr Cherokee
ny Chichewa
zh-CN Chinese (Simplified)
zh-TW Chinese (Traditional)
co Corsican
hr Croatian
cs Czech
da Danish
nl Dutch
en English
eo Esperanto
et Estonian
ee Ewe
fo Faroese
tl Filipino
fi Finnish
fr French
fy Frisian
gaa Ga
gl Galician
ka Georgian
de German
el Greek
gn Guarani
gu Gujarati
ht Haitian Creole
ha Hausa
haw Hawaiian
iw Hebrew
hi Hindi
hmn Hmong
hu Hungarian
is Icelandic
ig Igbo
id Indonesian
ia Interlingua
ga Irish
it Italian
ja Japanese
jw Javanese
kn Kannada
kk Kazakh
rw Kinyarwanda
rn Kirundi
kg Kongo
ko Korean
kri Krio (Sierra Leone)
ku Kurdish
ckb Kurdish (Soranรฎ)
ky Kyrgyz
lo Laothian
la Latin
lv Latvian
ln Lingala
lt Lithuanian
loz Lozi
lg Luganda
ach Luo
lb Luxembourgish
mk Macedonian
mg Malagasy
ms Malay
ml Malayalam
mt Maltese
mi Maori
mr Marathi
mfe Mauritian Creole
mo Moldavian
mn Mongolian
my Myanmar (Burmese)
sr-ME Montenegrin
ne Nepali
pcm Nigerian Pidgin
nso Northern Sotho
no Norwegian
nn Norwegian (Nynorsk)
oc Occitan
or Oriya
om Oromo
ps Pashto
fa Persian
pl Polish
pt-BR Portuguese (Brazil)
pt Portuguese (Portugal)
pa Punjabi
qu Quechua
ro Romanian
rm Romansh
nyn Runyakitara
ru Russian
sm Samoan
gd Scots Gaelic
sr Serbian
sh Serbo-Croatian
st Sesotho
tn Setswana
crs Seychellois Creole
sn Shona
sd Sindhi
si Sinhalese
sk Slovak
sl Slovenian
so Somali
es Spanish
es-419 Spanish (Latin American)
su Sundanese
sw Swahili
sv Swedish
tg Tajik
ta Tamil
tt Tatar
te Telugu
th Thai
ti Tigrinya
to Tonga
lua Tshiluba
tum Tumbuka
tr Turkish
tk Turkmen
tw Twi
ug Uighur
uk Ukrainian
ur Urdu
uz Uzbek
vi Vietnamese
cy Welsh
wo Wolof
xh Xhosa
yi Yiddish
yo Yoruba
zu Zulu

Original subtitles

- [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.