All language subtitles for 03 - Calculate expected value

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] When you analyze business scenarios,

you will often want to calculate

the expected value of an overall scenario

with multiple possible outcomes.

As an example, you might think that there would be

three scenarios and you have assigned probabilities

to each of them.

So the first scenario you believe is 30% likely,

the second scenario is 40%, and the third, 30%.

Each of those scenarios will lead to a value, or outcome.

So in scenario one, the value is $5,000, positive 5,000,

for scenario two, it's 10,000,

and for scenario three, that you would have

a loss of $10,000.

You can then calculate the expected value

for each of these scenarios.

To do that, you multiply the probability by the value.

So the expected value for scenario one,

which is 30% likely with a $5,000 value,

is 30% times 5,000 equals 1,500.

You can use the same calculations

to calculate expected value for scenario two of 4,000

and scenario three of minus 3,000.

You then add up all the expected values

to get the overall expected value for a scenario.

So that would be 1,500 plus 4,000

minus 3,000 equals positive $2,500.

So if you're evaluating an investment,

this appears to be a good way to spend your money

unless you can find something better to do.

Now, let's switch over to Excel

so that we can see how to implement this in a worksheet.

I have switched over to my Excel sample file

and that is 06_03_Expected Value.

You can find it in the Chapter Six folder

of the exercise files collection.

Here, I have three scenarios

and I have assigned different probabilities

and values to them.

You can see the probabilities in column B

and the values in column C.

And as noted in the first part of this video,

I want to multiply the probability by the value

of a particular scenario to get its expected value.

So I will select cell D2,

type an equals sign, and I'll multiply B2,

the probability of scenario one,

by the value in C2, which is the value,

and I'll press Enter.

And I see the expected value of scenario one, $50,000,

with a 25% probability is $12,500.

Now I will use the fill handle

to drag the contents of cell D2

so that it covers D3 and D4

and I get those calculations there.

So I have 60% times minus 25,000 equals minus 15,000.

And then for scenario three, 15% times 14,000 is 2,100.

Now to calculate the total expected value

for this business proposition,

I can click in cell B5 and I'll create an AutoSum formula.

So I'll press alt-equal,

I get SUM D2 to D4 and Enter,

and I see that I have an expected value of minus $400.

So that means according to my estimates,

I am likely to lose money on this investment

and I should not go ahead with it.

Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.